Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Jul 28, 2010 06:53 AM|LINK
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.