http://www.databasejournal.com/features/mssql/article.php/10894_2244821_2/Sequential-NumberingCounting-of-Records-with-SQL-Server.htm
Vedeti sectiunea Sequentially Numbering Groups of Records.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro