title: Creating a temp table without using SELECT INTO
body: <p>I am aware that I can use <code>SELECT * INTO</code> statements to create temp tables. </p>
  
  <p>However, is there any way to create temp tables using just a SELECT statement?</p>
  
  <p>Let's say I have some SQL like <code>SELECT * FROM Customers</code>, is it possible to write a query like below to create the temp table?</p>
  
  <pre><code>CREATE TABLE #Temp as (SELECT * FROM Customers)
  </code></pre>