What Data can I put into a Cursor? 1

[cmdematos]

I can get the result of a select statement into a cursor...

declare cr cursor for select * from clients

but I cannot seem to get the result of another stored procedure into the cursor...

delcare cr cursor for exec sp_get_from_clients

Is there a way to achieve this?

 

[tlbroadbent]

You can't put the output of a SP into a cursor directly. One work around is to create a temporary table, insert output of the SP into the table, and create the cursor on the temp table.

Example:

Create Table #Temp (<column definitions>)

Insert #temp
Exec sp_get_from_clients

declare cr cursor for select * from #temp Terry

http://members.home.net/tlbroadbent/index.htm