As a side note, this does get easier in SQL 2012 with OFFSET-FETCH:

http://www.dbadiaries.com/new-t-sql-features-in-sql-server-2012-offset-and-fetch