Adding an Order to Table

seananderson · June 28th, 2007, 05:48 AM

Is there a way to get the record number as part of a SQL query?

Code:

SELECT * FROM EMPLOYEE ORDER BY SURNAME

RECNO  FORENAME  SURNAME 
-----  --------  --------
1      John      Smith
2      Dave      Jones
3      Lee       Williams

Of course, RECNO is not in the EMPLOYEE table.

Regards,

Sean Anderson

sshelper · June 28th, 2007, 05:33 PM

In SQL Server 2000, one way to do this is to put the records in a temporary table where the table contains an identity column that will serve as your RECNO column.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp