Returning Ranked Results with Microsoft SQL Server 2005

In this article Scott Mitchell looks at SQL Server 2005's rank-related functions, which simplify the process of assigning ranks to query results, retrieve results with a particular rank, and other rank-related tasks common to reporting.