SQL server 2005 has 4 new ranking/windowing functions These functions are RANK(), DENSE_RANK(), NTILE() and ROW_NUMBER() I will show you all the hard work you have to do to implement RANK(), DENSE_RANK() and ROW_NUMBER() in SQL Server 2000