Select Query For Custom Paging

 Hi,

I
am working on this select query for a report on website users. The
resulting rows will be displayed in a datagrid with custom paging. I
want to fetch 100 rows each time. This is the simplified query,
@currpage is passed as a parameter.

________________________________________________________________________________

DECLARE @table TABLE (rowid INT IDENTITY(1,1), userid INT)

INSERT INTO @table (userid) SELECT userid FROM Users

SELECT T.rowid, T.userid, ISNULL(O.userid, 0)
FROM @table T
LEFT OUTER JOIN
(
SELECT DISTINCT(userid) FROM orders
)
AS O
ON O.userid = T.userid
AND T.rowid > ((@currpage-1) * 100)
AND T.rowid <= (@currpage * 100)
ORDER BY T.rowid
________________________________________________________________________________


If
I run this query it returns all the rows, not just the 100 rows
corresponding to the @currpage value. What am I doing wrong? (The
second table with left outer join is there as I need one field to
indicate whether the user has placed an order with us or not. If the
value is 0, the user has not placed any orders)
 
Thanks.