Paging In MSSQL

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

WITH ResultSet AS   (   SELECT ROW_NUMBER() OVER   (   ORDER BY   ErroLog.Field1,   ErroLog.Field2,       )AS RowNumber,   TableAliasName.Field1 AS LogID,   TableAliasName.Field2 AS UPL,       FROM TableName AS TableAliasName   WHERE TableAliasName.Field2 LIKE '111%'   )   SELECT * FROM ResultSet WHERE RowNumber BETWEEN BeginCounter AND EndCounter

NOTE> This will not work for a billion reocords or more than that but will work upto million quite easily. I don't know how to fetch when the result set contains more than million in MSSQL.