I am using ADO with VB6 and SQL Server 2000. My intentiion is to retrieve in
a "inteligent" way queries with a lot of records (1 million for example). I
want to retrieve "1000 records portions". I know how to process first portion
(using TOP or SET ROWCOUNT), but how to process following portions,
understanding that second portions begins with record no. 1001 and finishes
with record no. 2000. and third .... so on. Can you help me?

Beforehand, thank you very much.

--
Luis Garcia
IT Consultant