--===== Create and populate the temp table using the result set of a stored procedure
     -- as if it were a table.
 SELECT * 
   INTO #Temp
   FROM OPENROWSET('SQLOLEDB','Server=server\instance;Trusted_Connection=Yes;Database=Master', 
                              'Set FmtOnly OFF; EXEC dbo.sp_Who')

--===== Display the content of the new temp table to show it worked
     -- and then drop the temp table for reruns.
 SELECT * FROM #Temp
   DROP TABLE #Temp

--===== Create and populate the temp table using the result set of a stored procedure
     -- as if it were a table.
 SELECT * 
   INTO #Temp
   FROM OPENROWSET('SQLOLEDB','Server=server\instance;Trusted_Connection=Yes;Database=nameofdatabasehere', 
                              'Set FmtOnly OFF; EXEC dbo.usp_temp_InsSample')

--===== Display the content of the new temp table to show it worked.
 SELECT * FROM #Temp
   DROP TABLE #Temp

CREATE PROC usp_temp_InsSample
AS
BEGIN
SET NOCOUNT ON

CREATE TABLE #MyTable
(UID INT,NAME VARCHAR(100))

INSERT INTO #MyTable SELECT 1,'Name1' 
INSERT INTO #MyTable SELECT 2,'Name2' 
INSERT INTO #MyTable SELECT 3,'Name3' 

SELECT * FROM #MyTable

DROP TABLE #MyTable
END