Koen Verbeeck (2/15/2012)
Nice question. Didn't know triggers had such an impact on MERGE.
+1
I didn't really get the point you were making until I built the tables and the insert trigger, then everything became clear.
Thanks for highlighting this.
Ian