SQL: How to insert the result of a stored procedure to a temp table

Asked Jan 26 '18 at 11:28

Active Jan 26 '18 at 11:34

Viewed 52 times

I'm using SQL Server 2012. I have a stored procedure that outputs 2 tables. I need to insert those 2 result set in two separate temp tables. I am using

INSERT INTO #TempTable
EXEC [dbo].[SomeSP]

but it only catch the first table.

Is there anyone knows how to do it? Thanks in advance.

edited Jan 26 '18 at 11:34

a_horse_with_no_name

497,550
91
775
843

asked Jan 26 '18 at 11:28

Dudesville Hurynnx

1

https://stackoverflow.com/questions/5270843/query-that-returns-multiple-result-sets – Denis Rubashkin Jan 26 '18 at 11:38
1

[Another sense of deja vu](https://stackoverflow.com/q/48442793/4137916). – Jeroen Mostert Jan 26 '18 at 11:39

SQL: How to insert the result of a stored procedure to a temp table

0 Answers0