Hi!

Use a query like
select top 10 ... from ... Where ... AND ordernum > 11 order by ordernum

ordernum is a key field or order field or some expression. Use it to separate records. Last value for WHERE condition you can get from the last record of the previous query result. Because records are ordered, you should get correct results if "ordernum" is unique in the query. At the client side, however, you require to combine these partial record sets to a single one. Its hard also to organize updates in such case.

You can also try to use views, but I'm not sure it can help (they have some cursor properties).

>I am using SQL Pass-Through to pull a cursor from a remote database. The cursor is usually rather large and takes more time than what is desired to pull all the generated records down from the server. What would be the best to incrementally pull the records, i.e. records 1 through 10, then go back and get 11 through 20, and so on to the end? TIA.
>
>Bryan