Great example, and thanks for the info on the MERGE functionality.  A question about usage...

With this syntax:

WHEN SOURCE NOT MATCHED THEN

        DELETE

Can I put other things in there instead of "DELETE"?  I don't physically delete from my databases - we use a logical delete using an InactiveDate field.  Is there a way to set that InactiveDate field for those records that are in the source but not matched with any data in the XML (and therefore need to be "deleted")?

Thanks.