Store SP data in temp table

Question

Hello - I have the following SP and want to save the result of this SP in temp (#temp) table. Is it possible to save the result of SP's result data into #temp table?

Exec sales2021 @AB='ADC', @AC='DFG'

Answer 1

Hi @Mike ，

Please refer below:

-- Creating Temporary Table  
CREATE TABLE #temp(  
	Col1 [nvarchar](650) NULL,  
	Col2 [nvarchar](255) NULL  
)  
GO  
  
--Inserting Records from Stored procedure to Temporary Table  
INSERT INTO #temp  
Exec sales2021 @AB='ADC', @AC='DFG'  
GO  
  
-- Selecting Records from Temporary Table  
SELECT * FROM #temp  

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.