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
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.