title: Order by not working when insert in temp table
body: <p>I have a query, and when I execute it in SQL Server 2012, the <code>ORDER BY</code> clause is not working. Please help me in this. Regards.</p>
  
  <pre><code>DECLARE @Data table (Id int identity(1,1), SKU varchar(10), QtyRec int,Expiry date,Rec date)
  DECLARE @Qty int = 20
  
  INSERT @Data 
  VALUES
      ('001A', 5 ,'2017-01-15','2015-11-14'),
      ('001A', 8 ,'2017-01-10','2015-11-14'),
      ('001A', 6 ,'2015-12-15','2015-11-15'),
      ('001A', 25,'2016-01-01','2015-11-16'),
      ('001A', 9 ,'2015-12-20','2015-11-17');
  
  SELECT * 
  INTO #temp 
  FROM @Data 
  ORDER BY Id DESC
  
  SELECT * 
  FROM #temp
  </code></pre>