stored procedure output in temp table in sql server 2012.

You can use openrowset  and call the SP but there is another way to do same.

You need to know the output of the SP. Meaning what is the output of the stored proc?

Once you know the select statements coming out of SP, you need to create temp table before hand (before calling the SP) and then do insert into temp table.

 

Exec schema.SP params 

Hi,

 

Store Procedure is used to get the results from the DB but I couldnt get you why you need to store the result of SP into Temp table?