Insert Into temp table from a stored procedure that returns multiple result sets

Viewed 20578

Consider the following sql

A stored proc called myProc which returns two result sets. Result set 1 returns column1, column2. Result set 2 returns column 3, column 4, column 5.

The following sql will fail since the temp table only has defined 2 int columns.

Create Table #temp1(
Column1 int,
Column2 int)

insert into #temp1 exec myProc

My question is is it possible to just insert the first result set into #temp1?

2 Answers
Related