• I would personally use XQuery - a first class citizen in T-SQL

    IMHO loading XML documents is quite memory-hungry.

    Cheers