It would help if you included a CREATE TABLE statement for your table, as well as sample XML document. And from that example you could explain a little more closely what you want to achieve.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]