Specify number of returned records | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Specify number of returned records

Is there a way of specifying within a SQL Statement to only pull in a certain number of records that are stored in a table? E.g pull in records 1 – 10 as they appear in the database, and when finished with those 10 pull in the next 10 etc. (Some kind of a loop that will count how many records exist and keep showing records in a set of 10 until the end has been reached?)

Maybe this article can be helpful:http://sqlmag-pwf.texterity.com/sqlmag/200412/