A merge can be convenient but there are gotcha’s you need to understand. Merges run as more than one transaction so you have to be careful the rug doesn’t move under your feet between each section. In high concurrency environments it’s better to use classic approaches by using a combination of SELECT’s, INSERT’s, UPDATE’s and/or…