>>I have a program that is not been transfered to OOP yet. It generates commission amounts and then prints out too much paper. No data interaction, just give a date and print.
>
>I don't know what the real problem here, but IMHO the using of cursor would be more appropriated here, and would just simplify this case to the extent that error will disappear itself :-).

I love that advise. "KISS" I just took off the create SQL View portion of the command and placed the reusult dataset into a local table and poof the problem dissapeared. I just use that table alias() my view name and the sales staff won't cusre me in my absence!

Thanks again.