www.adOpenStatic.com/experiments/recordsetpaging.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Using MS SQL v7.0, I'm trying to develope a Stored Procedure that will
: return a given page, and then a given number of results in that page.
: i.e.  I want to select records 1-15, then 16-29...and so on.  Below is a
: solution that works using a temporary table, but I'm wondering if there is
: a different/better way do perform this action server side especially
: without using a temporary table.  I see that MySQL uses a "limit"
: paramater, but if I'm seeing things right, MS SQL does not implement such
: a paramater because the ANSI standard does not call for one.
:
: Thank you,
:
: TheBook
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~