title: create a temp table using union
body: <p>how to create a  temp table using a union operator</p>
  
  <pre><code>select top 5 Name into [#Production.Productmodel]
  from          [Production].[ProductModel]
  select top 5 Name into [#purchasing.shipmethod]
  from          [Purchasing].[ShipMethod]
  select Name into #productionprod
  select  Name from [#purchasing.shipmethod]
  union
  select  Name from [#Production.Productmodel]
  </code></pre>
  
  <p>but i still getting an error(invalid column name)</p>