April 19, 2005 08:19 PM
Assigning Row Numbers for Non-Unique Rows
A challenging but doable task
Rating:
(0)
SQL Server Magazine
InstantDoc ID #45828
I discussed the concept of row numbers many times in my T-SQL Black Belt articles because row numbers have numerous practical applications. You can find details about the ANSI set-based techniques that let you calculate row numbers in SQL Server 2005 and SQL Server 2000 in the article "Calculating Row Numbers in SQL Server 2005," April 2004, InstantDoc ID 42302.
In ...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: