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