title: insert into temp table without creating it from union results
body: <p>I have the below query that get results from more than one select.
  Now I want these to be in a temp table.</p>
  
  <p>Is there any way to insert these into a temp table without creating the table?</p>
  
  <p>I know how to do that for select </p>
  
  <pre><code>Select * into #s --like that
  </code></pre>
  
  <p>However how to do that one more than one select?</p>
  
  <pre><code>SELECT  Ori.[GeoBoundaryAssId],  Ori.[FromGeoBoundaryId], Ori.Sort 
  From [GeoBoundaryAss] As Ori where  Ori.[FromGeoBoundaryId] = (select distinct [FromGeoBoundaryId] from inserted )
  
  Union 
  
  SELECT  I.[GeoBoundaryAssId],  I.[FromGeoBoundaryId], I.Sort 
  From [inserted] I ;
  </code></pre>