Link to home
Start Free TrialLog in
Avatar of sabrina_spillane
sabrina_spillane

asked on

SQL Sever 2000 - How do I create a Cursor that returns data and stores it in a table

I am working with SQL Sever 2000 and I am trying to create a cursor that will run another stored procedure and return its resutls and store those resutls in a temp table.
CREATE cur_name CURSOR
FOR exec SP_runstored procedure
OPEN cur_name
then insert the results into a temp table #temptest which i have created?
Has anyone go any ideas on this. Thanks for all the helo in advance.

ASKER CERTIFIED SOLUTION
Avatar of ill
ill
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial