stored procedure output in temp table in sql server 2012.

Question

Hi team how to take stored procedure output in temp table in sql server 2012.

Tapan Patel · Answer

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. Inser into #tempTable Exec schema.SP params

Naveen Kumar · Answer

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?