I have yet to see a solution to the paging problem that I like. The problem with this solution (
http://www.4guysfromrolla.com/webtech/062899-1.shtml) is that the stored procedure copies the table to the temp. table everytime the it's called. On a busy server, that could be a lot of temporary tables and a lot of work done by SQL Server.
Just my two cents.
-Mike