certainly. I want to start simple so I'll start with multiple stored procs each one with a select query in. In reality I'll probably make it more complicated as I...

Hi,

Thanks for taking the time to help me. I cannot get the sample data to work using the code suggested in the link you posted. I get to the last...

figured it out

Thanks for your help

because I don't know how to. I'm new to using cursors and I am not sure how I would do that. This is why I am asking in a forum

Yes of course. What details would you like? At the moment it executes 20 separate select queries as the fetch goes through the while loop. I just want to take...

Hi,

Thanks for your reply. I thought this might be the only solution.

Cheers