Create a ## temp table, insert the result set into the ## temp from SP1, execute SP2, drop ## temp, need to ensure the code of SP2 references the ## temp table


CREATE TABLE ##Temp (ID INT)
go
INSERT INTO ##Temp
EXEC SP1
go
EXEC SP2
go
DROP TABLE ##TEMP