Getting record position in sql server 2000

[shilpa.vastrad]

hi

i am using SQL server 2000. I want to know the record position while
retrieving records. its like row_number() in sql server 2005

Is it possible?

[Tom van Stiphout]

On Tue, 25 Mar 2008 05:24:49 -0700 (PDT), sh************@gmail.com
wrote:

There rarely is a good reason for needing a row number. What is yours?
-Tom.

>hi

i am using SQL server 2000. I want to know the record position while
retrieving records. its like row_number() in sql server 2005

Is it possible?

[Erland Sommarskog]

Tom van Stiphout (no*************@cox.net) writes:

There rarely is a good reason for needing a row number. What is yours?

The row_number() function is one of the absolutely most useful additions
to SQL 2005. The only thing that can compete is the new error handling.
There are so many problems which are solved easily and efficiently with
the row_number function.
--
Erland Sommarskog, SQL Server MVP, es****@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

[shilpa.vastrad]

On Mar 26, 3:47 am, Erland Sommarskog <[e-mail]:

Tom van Stiphout ([e-mail]) writes:

There rarely is a good reason for needing a row number. What is yours?

The row_number() function is one of the absolutely most useful additions
to SQL 2005. The only thing that can compete is the new error handling.
There are so many problems which are solved easily and efficiently with
the row_number function.

--
Erland Sommarskog, SQL Server MVP, [e-mail]

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

thanks to all.
the solutions are pretty good. But not feasible to me. is any other
solution available. If so then plz help

[Erland Sommarskog]

(sh************@gmail.com) writes:

thanks to all.
the solutions are pretty good. But not feasible to me. is any other
solution available. If so then plz help

If they are not feasible to you, it would be a good thing if you could
provide more details the problem you are trying to solved, and why the
suggested solutions will not work for you.
--
Erland Sommarskog, SQL Server MVP, es****@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

[Ed Murphy]

sh************@gmail.com wrote:

On Mar 26, 3:47 am, Erland Sommarskog <[e-mail]:

>Tom van Stiphout ([e-mail]) writes:

>>There rarely is a good reason for needing a row number. What is yours?

The row_number() function is one of the absolutely most useful additions
to SQL 2005. The only thing that can compete is the new error handling.
There are so many problems which are solved easily and efficiently with
the row_number function.

--
Erland Sommarskog, SQL Server MVP, [e-mail]

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

thanks to all.
the solutions are pretty good. But not feasible to me. is any other
solution available. If so then plz help

Why aren't they feasible to you? Can you give an example with a small
amount of sample data, and explain in conceptual terms what you would
want to do with that sample data?