User
Reputation: 67
Insert data from stored procedure returning mutiple dataset into a temporary table in SQL Server 2008
My stored procedure returns more than one result set.
I want to get the data returned by the second select statement from the stored procedure and I want to insert that data in a temporary table in SQL Server 2008.
Any idea how to implement this ?
Upvotes: 1
Views: 702
Answers (1)
Craig Ottley-Thistlethwaite
Reputation: 36
You can't access more than one result set in SQL Server. A couple of options though:
Split the stored procedures so only one result set it returned. Access the second result set using c#/vb/net data tables. Create a CLR to access the second result set.
HTH
C
Upvotes: 1
Related Questions
- Insert results of a stored procedure into a temporary table
- insert return data from SP to temp table
- Insert stored procedure results into temp table
- How to insert wide result set from stored procedure into a temporary table or table variable?
- SQL's stored procedure multiple result into temp table
- Using a temp table to insert in stored procedure
- SQL - Insert Stored Procedure Results into Temp Table
- Insert data into Temp table from a stored procedure
- insert multiple table data in a temp table
- Insert Into temp table from a stored procedure that returns multiple result sets