If you like to write client side pagination because its so easy, its time to change that. Irena's stored procedure for Easy Pagination in SQL
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.