OFFSET/FETCH was introduced in SQL 2012 specifically to handle paging, which is what you are trying to do.

Drew