dwain.c (7/17/2013)
Brandie Tarvin (7/17/2013)
WHOO HOO!Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly with a Cross Applied Tally table and an INNER JOIN inside the USING clause.
<SnoopyDance>
And it only took me 30 minutes to figure it all out.
One thing to take care with when using MERGE though: A Hazard of Using the SQL Merge Statement[/url]
It's not a bug it's a feature, but does have the potential to cause you grief if you don't know about it.
Okay. Read the article. Reread it again. I understand the conclusion, but the content was a little iffy. There are certain assumptions made about the reader understanding what the writer was doing without setting up a plain English business case. So I'm still confused on why the author decided to deliberate throw in a DELETE on the NOT MATCHED BY SOURCE bit and then act surprised when it worked as advertised.
Thanks for the link, though.