If you are using SQL Server 2000, you have a number of options which are explained here: http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html. The article looks at paging records in classic ASP. so the first half of the article is irrelevant, but further down, there are a number of stored procedure options that work. Aaron Bertrand found the last Stored Procedure options - the one that uses ROWCOUNT to be the best performer. Don't just grab the first one in the list.