title: INSERT INTO with exec with multiple result sets
body: <p>SQL Server allows me to insert the returned result set of a stored procedure as:</p>
  
  <pre><code>DECLARE @T TABLE (
    ID int,
    Name varchar(255),
    Amount money)
  
  INSERT INTO @T
  exec dbo.pVendorBalance 
  </code></pre>
  
  <p>This works as long as the stored procedure only returns 1 result set.</p>
  
  <p>Is there a way to make this work if the stored procedure returns several result sets?</p>
  
  <p>E.g.</p>
  
  <pre><code>DECLARE @T1 (...)
  DECLARE @T2 (...)
  
  INSERT INTO @T1 THEN INTO @T2
  exec dbo.pVendorBalance 
  </code></pre>