I do not know how to solve this problem.
I want to get total 1000 records from sql Server. In the first time, I got 100 records using "Set ROWCONNT 100" statement. How can I get the next 100 records without generate a recordset that including the first 100 records that I have already got? Thanks in advance.

------------------
y