Limits in SQL 2000

I have a database with 10,000 records and I want to just see record
1000 - 1025 is there an easy way to do this with a query. I have found
info for my SQL using limits but it does not work with SQL Server 2000.
Please help.

Thanks in advance.Robert P (rphilipson@.legaleze.com) writes:

Quote:

Originally Posted by

I have a database with 10,000 records and I want to just see record
1000 - 1025 is there an easy way to do this with a query. I have found
info for my SQL using limits but it does not work with SQL Server 2000.

Assuming that you want to do paging for display on a web page,
see SQL Server MVP's Aaron Bertrand article on the topic on
http://www.aspfaq.com/show.asp?id=2120.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx