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?