First pass at fixing SQL Server 2000 pagination

This is an attempt to restore SQL Server 2000 pagination while reusing the existing local variables.
Can you write a quick example for the type of SQL query we're matching for? :) Thanks!