mssql server 2005 paging
SET @RowStart = @PageSize * (@Page-1) + 1;
SET @RowEnd = @RowStart + @PageSize – 1 ;
SELECT * FROM (
SELECT RowNumber() OVER(order by USER_ID) As RowID,
COUNT (USER_ID) OVER (PARTITION BY null) AS TOTAL_ROWS,
name
from usertbl
) As RowResults
WHERE RowID Between @RowStart AND @RowEnd
Order by RowID asc