Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by M. Choirul Amri SQL 2005 for the SQL2K Developer Part 2 RE: SQL 2005 for the SQL2K Developer Part 2

  • May 10, 2006 at 9:16 pm

    #637145

    Don't forget RANK(), DENSE_RANK() and NTILE().  See http://www.sqlservercentral.com/columnists/mcoles/sequentialordering.asp for more info.  Also discusses other reasons IDENTITY column and other options are not optimal solutions.

    Thanks.