declare @NumRows int
declare @i int

SET @NumRows = 10 --return 10 rows at a time
SET @i = 3 --i want the 3rd resultset, 30-40
SELECT * FROM (
SELECT 
  row_number() OVER(ORDER BY name) AS RW,
  sysobjects.*
FROM sysobjects ) myAlias
WHERE myAlias.RW BETWEEN (@NumRows * @i) 
                 AND     ((@NumRows * @i)+ @NumRows)