Take a look at this:
DECLARE @ActualRow = 1;
DECLARE @ItensCount = 100;
DECLARE @Page = 1;
SELECT * FROM
(SELECT *, ROWNUMBER() OVER(ORDER BY Name) as ROWNUM FROM Users) as Us
WHERE ROWNUM BETWEEN @ActualRow AND (@ActualRow + @ItensCount / @page) -1
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.