The SQL Server procedure returns multiple tables. Insert results into tables.

Question

I have a procedure that returns multiple tables; eg:

PROCEDURE Something AS
BEGIN
 SELECT 1,2,3
 SELECT 4,5
 SELECT 9,10,11
END

I would like to extract each table from the result and insert it into a series of tables / temporary tables - one for each record set.

Is it possible?

Answer 1

if you combine the results together, they will come out as one set of results.

your second query has only 2 columns, but this will need to be resolved anyway when you put it in a table.

Answer 2

. , .

sp .

Answer 3

Check for multiple active result sets (MARS). He can do what you seek.

http://www.sqlteam.com/article/multiple-active-result-sets-mars

http://blogs.msdn.com/sqlprogrammability/archive/2006/05/01/MARSIntroduction1.aspx