Looking for a good article on paging in a HTML message board system using
SQL Server 2000.
I'm aware that there are a lot of articles out there about paging large
recordsets, but none that I've seen look to be particular good. The main
requirement is to be able to efficiently go to an arbitrary page number,
this requirement is an often overlooked area.
I'm looking for a solution that makes little or no use of temporary tables,
and instead relies on changes to the database schema with increased changes