How to create temporary table
select * into #temp_purchasereturn from(

  )as tab          
select ROWID=IDENTITY(int,1,1),* into #temp_purchse1 from #temp_purchasereturn order by TaxRate                             
select * from #temp_purchse1                           
DROP TABLE #temp_purchasereturn                              
drop table #temp_purchse1