mburbea (5/7/2014)
Paul do you have a similar trick that will work in the output clause? Output statements do not allow subqueries
You can't put the EXISTS...INTERSECT check in the MERGE statement body?
Can you post a complete repro (perhaps as a new question?) I sort of see what you're getting at, but a complete code example with sample data and expected output always helps avoid unnecessary to-and-fro.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi