I apologize and hope I have what is needed now. I have created the CREATE TABLE and INSERT scripts in the attached Word document. I did have to change the...

Thanks all for the help!

Hi Drew, this seems to work great! I made a slight tweak to the final select to output rows 1 and 2 (the 'new' and 'old' rows). Question, is there...

Thanks - I figured they were there more as proof of concept. I adapted it using the actual tables and it seems to work perfectly and fast!

[code...

Thanks for the reply. Is that the only way to accomplish this is by creating temp tables? I thought there may be a little more simplistic approach...