Here is one way to emulate ROW_NUMBER in SQL Server 2000, but be aware this
can be very slow with large data set:

CREATE TABLE Foo (
keycol CHAR(2) PRIMARY KEY,
datacol CHAR(1))

INSERT INTO Foo VALUES ('AA', 'a')
INSERT INTO Foo VALUES ('AC', 'c')
INSERT INTO Foo VALUES ('BC', 'd')
INSERT INTO Foo VALUES ('BA', 'e')

SELECT keycol,
datacol,
(SELECT COUNT(*)
FROM Foo AS B
WHERE B.keycol <= A.keycol) AS rn
FROM Foo AS A
ORDER BY keycol

HTH,

Plamen Ratchev
http://www.SQLStudio.com