We need to copy some columns for new and amended clients from an in-house database to a 3rd-party one. The original process involved copying the data to an intermediate database (with some massaging) and then processing new clients via a cursor before using a similar cursor to process the changes. Unsurprisingly, this took some time. The replacement does away with the intermediate database and doesn't use cursors.
Old and new stored procedures in the attached document.