SQL Server - Selectively inserting fields into temp table

Question

I am executing a SP within a SP. The SP returns say 10 params. I am interested in only 5 of them. How do I insert only these 5 into the temp table.

The code I have so far:

  DECLARE @tmpUnion TABLE
  (
    UnionCode VARCHAR(10),
    UnionDate DATETIME,
    UnionPosition VARCHAR(30),
    UnionInitFees BIT,
    UnionDues BIT
  )

  --getDetails returns 10 params. I need only these 5
  INSERT INTO @tmpUnion
  (UnionCode, UnionDate, UnionPosition, UnionInitFees, UnionDues)
  EXEC getDetails
        @iUserId = @OriginalLoginId

Answer 1

You can't. The table variable must match exactly the structure of waht is being returned.

Answer 2

Put the result of getDetails into a tablevar that contains all of the return values, then do your insert off of the additional table.

You might also check out this site for more information on how to share data between stored procedures.

Answer 3

Use OPENROWSET like so:

Select 
       *
from OPENROWSET('SQLOLEDB','Data Source=Server_name;Trusted_Connection=yes;
      Integrated Security=SSPI','Execute yourdb..get_orders')

Now you can easily filter the resultset

Select 
employeeid,orderid,orderdate 
from 

OPENROWSET('SQLOLEDB','Data Source=Server_name;Trusted_Connection=yes;
       Integrated Security=SSPI','Execute yourdb..get_orders')

where
       orderdate>='19960101' and orderdate<'19970101'

You don't need to create a temp table and you also don't need to worry about the structure of the procedure.

Found here

EDIT: Final solution moved from comments after discussion.