Create a temp table with same columns as your original table and additional identity column. Use insert into #temptable select column1, column2 ... from originaltable and query the temp table.