.... also in the merge you could have a condition not to update if the value is the same:-

-- MERGE

MERGE #Target t

USING (@ID, @VALUE)

...

Morning all,

I think the way that the MERGE source table has been written would definitely under perform compared to the upsert.

e.g.

-- MERGE

MERGE #Target t

USING #Source...