Something like
SELECT * from table where primarykey !IN (select primarykey from destinationtable)
The syntax may be a little off.
>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.