T-SQL SQL Server 2005 and 2008 Ranking Functions ceusee 2010. 4. 5. 00:06 http://www.mssqltips.com/tip.asp?tip=1952