使用CTEs不更新记录的SQL更新

I am attempting to update a set of records that are duplicates in three particular columns. The reason for this update is that there is a conflict when trying to insert this data into an updated database schema. The conflict is caused by a new constraint that has been added on I am attempting to update a set of records that