Is there a way to work on a recordset returned from an exec within another SP? The whole recordset, preferably not using OUTPUT
I.E.
MyStoredProcedure @var1 int AS BEGIN
EXEC anotherSP @var1
-- do something against the recordset returned by anotherSP
END