Here is a great article on paging in SQL 2005, I knew about the Row_Number() function but not the Rank() or Dense_Rank().



Continue reading ...