(shilpa.vastrad@gmail.com) writes:
> how to calculate rank in selected records in sql server 2000

Since the suggestions you got for row_number were not feasible to
you, but I was never told why, I don't feel like spending more time
without knowing what you are looking for.

Could you please give a more detailed description of your problem.
Preferrably you should give us:
o CREATE TABLE statement(s) for your tables.
o INSERT statements with sample data.
o The desired results given the sample.
o A short descrition of why you want that result.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx