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]