title: MS SQL SP - Working with EXEC recordset
body: <p>Is there a way to work on a recordset returned from an exec within another SP? The whole recordset, preferably not using OUTPUT</p>
  
  <p>I.E.</p>
  
  <p>MyStoredProcedure
      @var1 int
  AS
  BEGIN</p>
  
  <p>EXEC anotherSP @var1</p>
  
  <p>-- do something against the recordset returned by anotherSP</p>
  
  <p>END</p>