SQL Server 7.0 doesn't have table variables. You'll have to use temp. tables.

Basically, create a temp table that has the same structure as your result set but with an addition column that is an IDENTITY column. Insert your results into the temp table and then select from the temp table

rowid BETWEEN start AND stop

where rowid is the IDENTITY column. I was really surprised at the performance.

-Mike