title: Is it possible to use the SELECT INTO clause with UNION [ALL]?
body: <p>In SQL Server this inserts 100 records, from the Customers table into tmpFerdeen  :-</p>
  
  <pre><code>SELECT top(100)*
  INTO tmpFerdeen
  FROM Customers
  </code></pre>
  
  <p>Is it possible to do a SELECT INTO across a UNION ALL SELECT :-</p>
  
  <pre><code>SELECT top(100)* 
  FROM Customers
  UNION All
  SELECT top(100)* 
  FROM CustomerEurope
  UNION All
  SELECT top(100)* 
  FROM CustomerAsia
  UNION All
  SELECT top(100)* 
  FROM CustomerAmericas
  </code></pre>
  
  <p>Not too sure where to add the INTO clause.</p>