AFAIK, there's not a recno() style row-level variable in SQL Server. You may need to rethink approaches to this. Try a TOP X Clause with a specific order (maybe a "tModify" - style date of update, or an identity column).
>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.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
