The fact is that I am looking for a generic way to implement paging. Not just on partners table. On any table with ANY number of rows. That includes tables that...

240 was just a random number. The fact is that I am looking for a generic way to implement paging. Not just on partners table. On any table with any...

I quote my P.S. 2 in my first post:

"I know that I can fetch the results in variables, insert those variables in a temp table (or a table variable) and then...

I did not have this article in mind, however I have already implemented a similar solution.

The point remains that I want to avoid the overhead (in terms of processing)

1: of creating...

Yes, I do have a primary key (PK) on the table. I have thought of your solution, but there are drawbacks. Namely:

1. My PK may be 2 or 3 or...

I know I can do that, but I want to produce just one result set.

Thanks anyway.

Thanks for your reply.

This seems to be working ok in T-SQL for Sybase, but not in T-SQL for SQL Server.

I am using SQL Server 2000...