Inserting Stored Procedure Results into Temporary Tables in SQL Server

You can insert stored procedure results into a temporary table in SQL Server using INSERT INTO … EXEC, OPENROWSET, and handle multiple result sets.

Read more