>>Mike, thanks for your response. But wouldn't your solution imply reading all the records at the server-side after all ?
>
>This is true. You do have to generate the entire result set, or at least a keyset, on the server for each page. But, in a couple of years of trying to find a solution, this is the best that I've seen and used that does not involve dynamic SQL.
In that case I'd better give up on this. Stupid.
In that case MSSQL (or any) will never win from native DML on performance, will it ?
>
>>> where I'd like to achieve that some RV of the result is stored at the SQL Server.
>
>RV??
Remote View.
>
>-Mike