title: Insert results of stored procedure with multiple parameters into a temp table
body: <p>I created a stored procedure that requires the user to specify multiple parameters. The following script returns the correct results:</p>
  
  <pre><code>Execute dbo.Stored_Procedure_Name 
              @Ord1 = 1, @Ord2 = 4, @Ord3 = 5, @Ord4 = 6, @Ord5 = 7,
              @Table_Name = 'Random_Table_Name'
  </code></pre>
  
  <p>Now all I need to do is put the results into a temp table as the result set is the basis for a larger query that is setup to run off of a temp table. I've found lots of examples online of how to do this (including <code>OPENROWSET</code>) but haven't been able to locate something that leverages a stored procedure that requires multiple parameters. Other examples assume the user knows the column headers and can create a table before running the script, which I do not. </p>
  
  <p>Any guidance you may be able to provide would be greatly appreciated!</p>
  
  <p>Thanks! </p>