title: Insert results of a stored procedure into a temporary table
body: <p>How do I do a <code>SELECT * INTO [temp table] FROM [stored procedure]</code>? Not <code>FROM [Table]</code> and without defining <code>[temp table]</code>?</p>
  
  <p><code>Select</code> all data from <code>BusinessLine</code> into <code>tmpBusLine</code> works fine.</p>
  
  <pre><code>select *
  into tmpBusLine
  from BusinessLine
  </code></pre>
  
  <p>I am trying the same, but using a <code>stored procedure</code> that returns data, is not quite the same.</p>
  
  <pre><code>select *
  into tmpBusLine
  from
  exec getBusinessLineHistory '16 Mar 2009'
  </code></pre>
  
  <p><strong>Output message:</strong></p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 2
    Incorrect syntax near the keyword
    'exec'.</p>
  </blockquote>
  
  <p>I have read several examples of creating a temporary table with the same structure as the output stored procedure, which works fine, but it would be nice to not supply any columns.</p>