You appear to be going down the right road here.   If the data in EVERY one of the xml files has the exact same schema, then my code would be...

With apologies to Disney, kids everywhere, and this forum's readers:
The most wonderful thing about Triggers,
is triggers are dangerous things!
Their insides are made out of queries,
Their outsides...

How about at least using SET NOCOUNT ON to prevent additional result sets from occurring that might not be doing you any favors?   The other thing to check is what...

I can think of another example of when to use one.   I had a work scenario where the business rules for placing a new phone number into a given "slot"...

Turns out that the formula in question:
=c3-(PRODUCT(c3-DATE(YEAR(c3),{4,11},1-WEEKDAY(DATE(YEAR(c3),{4,11},0)))-1/24)<0)/24

just takes any given datetime value, and within that value's year, subtracts one hour whenever the value is between March 30th...

I'll have to partially retract that last post... I looked up curly braces and found it's an "array formula" in Excel.   I actually HAVE seen that before, but it was...