>>If only the data content gets updated (and not the number of records) and if there is a common key that does not get changed by your test run, then things become incredibly simple:
SELECT * FROM TableOne ;
>>UNION ;
>>SELECT * FROM TableTwo
If the resulting cursor (or table) RecCount() has increased then there are rows with duplicate keys. Do another SQL select where CNT(Key) > 1. This should result in only those records where data has changed - hopefully reducing the work involved in locating the changed data.
>
>I was waiting for you to add this Houston. Used it again just yesterday and it works beautifully. Many thanks again.
If you've added code to make things more generic and/or more sophisticated, then you might want to post it in the Files Section.
censored.