Home Forums SQL Server 7,2000 Performance Tuning Numbering the ResultSet - Equivalent of Rownum RE: Numbering the ResultSet - Equivalent of Rownum
Allen Cui-55137
SSC Guru
Points: 51650
More actions
July 18, 2003 at 8:17 am
#466059
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.