… Implement pagination using CTE in SQL Server 2005

Paging is a technique where you return a selected set of rows in a ordered manner, for e.g. records from 1-10, 10-20 or 3-7 etc. You must have seen this technique while accessing your mail on say HotMail or Yahoo or GMail. They provide you with a list of mails which have from 1-10 and [...]