Insert or Update using merge statement on a repeated identical row sqlserver I have two tables with identical fields, as below.