Pregunta

Puedes Probar con esto Espero Te sirva ( Ms- SQL 2000 )

USE Northwind
GO
select customerid, orderdate, orderid,
( select count(*)from dbo.orders as b
where b.customerid = a.customerid and
( b.orderdate < a.orderdate or
( b.orderdate = a.orderdate and b.orderid <= a.orderid )
)
) as rn
from dbo.orders as a
order by customerid, orderdate, orderid
Go