>>not sure if I have a correct mental picture, but assuming you have a already consolidated table you currently plan to get the missing data from, might it not be easier to get a copy from there of all records with pk in [PkFoundInDataset] itno a temp table and only update this temp table with existing/found values from the dataset ?
>
>Yes, this is exactly the goal.
>
>I just do not want to go with a syntax such as:
>
>

>SELECT Table.FirstName
> FROM Table
> WHERE Table.PrimaryKey=1 OR Table.PrimaryKey=2 OR Table.PrimaryKey=3 OR Table.PrimaryKey=4
>

>
>If I have 2034 records, that will be long. I am sure there is a better syntax, such as an inlist approach, at the SQL command.

SELECT Table.FirstName
 FROM Table
 WHERE Table.PrimaryKey in (1,2,3,4)