从另一个具有结果集的SP调用SP

Parent SP 
(
 Student INT
 Teacher INT
 Name Varchar
)

Child SP [Get Student specific activities] Student

-- Result Set of Child SP needed Here

-- End of Parent SP

CREATE TABLE #Temp (StudentId int null, <Other columns as required>)

INSERT #Temp
 EXECUTE ChildSP