Simulate ROW_NUMBER in SQL 2000 - SQL Server Planet

23 May 2010 ... SQL Server Max SmallInt Value ... feature, there are still ways to implement that same functionality in SQL Server 2000. ... OR (s2.qty = s1.qty AND s2.empid

sqlserverplanet.com