>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
Mike,
I can see how that would be a problem...I had not implemented that solution but was thinking about giving a whirl.
Thanks for throwing in your 2 cents (and saving me some time),
Steve Gibson