Replication is going to overwrite values for a column that is included in the replication set of stuff to be replicated.   Expecting to over-write those values using temporal features just...

Step 1.   Stop posting it anywhere, and especially having it in your registration with sites like Google, Twitter, Facebook, and pretty much ALL of the social media sites.
Step 2. ...

I don;t know much about temporal features, but I do know that replication tables that need to be different from their source tables because there are some things replication isn't...

I've heard quite a bit about MERGE over the years, with much of it in the category of "MERGE is unreliable", and given the occasional difficulty in figuring out exactly...

As your code works, and gets the possible combinations via recursion, the only thing you may have to worry about is performance.   To eliminate your duplicates, however, you need an...

You may well be out of luck....   nvarchar(max) or varchar(max) is going to cause it's own set of issues for the table involved, as for some rows the data is...