Hi Michael,

Thanks for the reply, I really appreciate it.
I have a question with the code you suggested. Can I use the passed parameter @tcSQL in the:

DECLARE cursorname CURSOR FOR statement?

I want to do this because I want to loop through the records that will be returned using: FETCH NEXT FROM statement


Thanks again...