just a wee thought on this article. Surely what you are talking us through here is the same as is accomplished by the Slowly changing dimension 'box' . Which automagically creates all the tsql to do the updates,additions and deletions. With support for keeping a history of changes.

It's quite a mad one but a bit of reading up on slowly changing dimensions really helps! 🙂