Luis Cazares (10/6/2014)
Not sure if I can call it luck. The one in charge of this process decided to remove the MERGE and use a combination of update and insert (or maybe delete and insert). It's no longer a problem, but we didn't find a solution using MERGE.
I use MERGE substantially and find that one cannot expect it to behave to intelligently, somewhat like a cooker does the boiling/frying part but the chief has to prepare/portion/time things etc.
😎