How to use 2 cursors, both not really related to each other.
Posted on 2011-09-06
I have a stored procedure which uses a cursor , which is looped in turn, to insert into a table.
Now, there is another cursor, which is not related to the first cursor, but will insert into the same table as the first cursor does.
how do i declare and use this second cursor outside of the first one? Please help.