SQL Server - Server-side paging with Row_number() function

If you are a programmer working with SQL Server, you must have found it little embarrassing to display information which spans across multiple pages (web pages). SQL Server 2000 did not allow you to retrieve a specific range of records, say, records 51 to 100 ordered by a certain column. For example, assume that you are working on a web page which lists the names of all the cities in different