Article Discussion: Sequential Numbering and Counting of Records

Microsoft SQL server does not support a method of identifying the row numbers for records stored on disk, although there are a number of different techniques to associate a sequential number with a row. You might want to display a set of records where each record is listed with a generated number that identifies the records position relative to the rest of the records in the set. In other cases, you may want to sequentially number groupings of records where each specific set of records are numbered starting at 1 and incremented by 1 until the next set is reached, where the sequence starts over. This article will show a number of different methods of assigning a record sequence number to records returned from a query.


Read the full article here: Sequential Numbering and Counting of Records