SQL Server - I have a web application using SQL Server 7.0 that returns the results of a query page. Si

I have a web application using SQL Server 7.0 that returns the results of a query page. Since a query could return thousands of rows I only display 50 at a time for speed. The user then hits the next arrow to display rows 51 - 100.  I would like to be able to do all of this in a stored procedure but I have not figured out how to do so using Sql. I know about the Top 50 but that doesn't help me with the next 50 or the next 50 after that. I have stumped several DBAs with maybe Here can help?

This concept is called "paging".  Newer versions of SQL Server offer you ways to do this fairly easily.  However, SQL Server 7 doesn't.  So, you'll need to search on "Paging data in SQL Server 7.0"