Alex Kozak writes that SQL Server's ranking functions are a great enhancement to Transact-SQL: Ranking Functions and Performance in SQL Server 2005 http://www.sql-server-performance.com/ak_ranking_functions.asp Shane Tasker -- Contributing Editor, SQL-Server-Performance.Com Independent Consultant