SQL Server developers and database architects often find they have a need to sequence query results or generate a cumulative sum for a group of rows in a table. Learn how to use co-related sub-queries and/or identity functions to generate such sequential numbers and cumulative summations in query results.

This story continues at http://www.databasejournal.com/featu...le.php/3373861