title: Stacking multiple tables in SQL server
body: <p>I am essentially trying to do a UNION all on multiple tables and have the result be a new table. I know that I can do this to select and stack all of the rows:</p>
  
  <pre><code>SELECT * FROM table1
  UNION ALL
  SELECT * FROM table2
  UNION ALL
  SELECT * FROM table3
  ....
  </code></pre>
  
  <p>But how do I make that into its own table?</p>
  
  <p>Thanks!</p>