create a temp table and openrowset your stored procedure data into it

INSERT INTO #tmp_table

SELECT *

FROM

OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off EXEC [ServerName].dbo.[StoredProcedureName] 1,2,3')