Basically we have 2 options to push Stored Procedure results.
1. If you do not know the schema and you may need to generate the schema during run time.
-- Change your instance Name SELECT * INTO #sp_whoResults FROM OPENROWSET('SQLNCLI', 'Server=localhost\mssqlserver2014;Trusted_Connection=yes;', 'EXEC sp_who') GO select * from #sp_whoResults
NOTE: You may not be able to use above solution in all scenarios (Ex: SP_Who2)
2. If you know the schema, and if the table already exists, you can use following method to add records into the table.
truncate table #sp_whoResults GO insert into #sp_whoresults EXEC sp_who GO select * from #sp_whoResults