I routinely receive updates to an existing table. I want to compare the old table to the new and record (in another table or view) only updated, added or delted records. I can write a program that will compare each record field by field, but can't help but think there might be an easier way.

Any thoughts?

Thanks