Welcome ALL

Adding Application pools in IIS http://www.iis.net/configreference/system.applicationhost/applicationpools/add

Update one table from another table :- UPDATE #temp1 SET #temp1.t3=#temp 2.t3,   #temp1.t4 = #temp2.t4   FROM #temp1, #temp2   WHERE #temp1.row = #temp2.row

To get tempary row number SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) AS Row, colnam1, colnam2  FROM table1