>Hi All,
> I have two tables that are supposed to be identical. One is at the home office and the other at a remote location. I was thinking of comparing each record one by one, but I was hoping there was an easier way. Has anyone had to compare two tables before and update the one that is outdated?
>Thanks,
If you do this on a regular basis, you may want to mark the modified records, instead (this can't be done with a trigger - "illegal recursion" or something), or use a trigger to post information on modified records to a separate table.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)