CREATE TABLE #tmp (<column_list>)
INSERT INTO #tmp EXEC MyProc
SELECT <columns> FROM #tmp