title: SQL Server Procedure returns multiple tables - Insert results into tables
body: <p>I have a procedure that returns multiple tables; eg:</p>
  
  <pre><code>PROCEDURE Something AS
  BEGIN
   SELECT 1,2,3
   SELECT 4,5
   SELECT 9,10,11
  END
  </code></pre>
  
  <p>I would like to take each table from the result and insert it into a series of tables/temp tables - one for each record set.</p>
  
  <p>Is this possible?</p>