• I was working with SQL 2008 R2 and found that to use delete when there is no match, the syntax got changed.

    Instead of

    "WHEN SOURCE NOT MATCHED THEN

    DELETE;"

    It is now

    "WHEN NOT MATCHED BY SOURCE

    THEN DELETE;"

    Hope you guys have noticed. But Just an FYI