Michael,

Have you found a better solution to paging yet?

I am working with ADO.NET and html table paging of datasets and I think the problem needs to be solved with T-SQL since we don't want to create a dataset with more than the pagesize number of rows, right?

>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