• And the XML document made it to the table?

    And more importantly, did you ran the code that I posted, with the XML file you submitted as C:\Temp\test.xml? Or did you translate my code to your actual table?

    I ran my test on SQL 2012, but I don't think the version of SQL Server should matter.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]