ДобрыйМакса почему тебе не нравится мерж?

А потому что ты доку не читаешь:

докaSpecify the DELETE where_clause to clean up data in a table while populating or updating it. The only rows affected by this clause are those rows in the destination table that are updated by the merge operation. The DELETE WHERE condition evaluates the updated value, not the original value that was evaluated by the UPDATE SET ... WHERE condition. If a row of the destination table meets the DELETE condition but is not included in the join defined by the ON clause, then it is not deleted. Any delete triggers defined on the target table will be activated for each row deletion.


Т.e. MERGE вначале выполнит UPDATE/INSERT и только затем DELETE? Оно тебе надо?

SY.