title: How to combine SELECT and INSERT commands into a non existent table in SQL Server?
body: <p>How does one combine the <code>SELECT</code> and <code>INSERT INTO</code> commands and insert the results into a temporary table in SQL Server? </p>
  
  <p>Something like this:</p>
  
  <pre><code>INSERT INTO #TempTable 
      SELECT * FROM MyTable;
  </code></pre>