Wednesday, March 28, 2012

Putting data from a store procedure into a cursor

The tile says it all... How to put into a Cursor the result of a procedure that selects certain rows.1. Create a temp table (not a table variable).
2. INSERT #table(column_list) EXEC procedure
3. Load the cursor.

No comments:

Post a Comment