PHWinfo - Afficher un message - Getting record position in sql server 2000

26/03/2008, 18h15

shilpa.vastrad@gmail.com wrote:

> On Mar 26, 3:47 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
>> Tom van Stiphout (no.spam.tom7...@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, esq...@sommarskog.se
>>
>> 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

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?

26/03/2008, 18h15	#8
Ed Murphy Messages: n/a Hébergeur:	Re: Getting record position in sql server 2000 shilpa.vastrad@gmail.com wrote: > On Mar 26, 3:47 am, Erland Sommarskog <esq...@sommarskog.se> wrote: >> Tom van Stiphout (no.spam.tom7...@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, esq...@sommarskog.se >> >> 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 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?