Nice article.

Would it also be possible to look at the same processes where the XML data is arranged like...

Jacob

NY

SQL Server

Steve

SQL Server

Bob

CA

Which include blank elements.

Have already been caught out with data like this needing insert/modify depending if a value exists

Thanks

Andy