C'mon. Someone must want to figure out this process.

From what I remember we did an insert of all new records (changed and truly new). Then there was an update to expire the old record. But for the life of me I can't remember the syntax of the joins.