Simulate ROW_NUMBER in SQL 2000

Posted by Derek Dieter on SQL Server Planet See other posts from SQL Server Planet or by Derek Dieter
Published on Sun, 23 May 2010 08:51:21 +0000 Indexed on 2010/05/23 8:52 UTC
Read the original article Hit count: 458

Filed under:
While the row_number feature in sql 2005+ has proven to be a very powerful feature, there are still ways to implement that same functionality in SQL Server 2000. Let’s first look at the SQL 2005+ implementation of ROW_NUMBER, then compare it to the SQL 2000:-- SQL 2005+ SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY c.LastName ASC) ,c.LastName ,c.FirstName FROM [...]

© SQL Server Planet or respective owner

Related posts about SQL Server 2000