I am trying to figure out how to get a set of rows/records from MSSQL. This is for a nightly batch process where I need to grab just parts of the table at a time. If this was VFP I would
"select * from table where recno() between 1 and 4000"
and then
"select * from table where recno() between 4001 and 8000"
What is the MSSQL equivalent?

Thanks.