Nice article. I've used this type of method often, and this article explains it very well.

Using RowNumber() could be avoided by adding an identity column on the new_purchase table and...

This is also not catering for binary/varbinary columns correctly