>So you want to implement paging? The best way that I've found to date is to write the results of the query to a table variable and pull the rows that you want in the page from the table variable. You can add an identity column to the table variable and simulate a record number.
>
>-Mike
Mike, thanks for your response. But wouldn't your solution imply reading all the records at the server-side after all ? If so, I might agree that it is "a" solution, where I'd like to achieve that some RV of the result is stored at the SQL Server. That is, if it can be done. This looks like "fake" btw.