基于xml字段中与T-SQL连接的值更新表中的xml特定节点。

I must gave this problem a lot of time and searching. I even almost get the output, but the problem is the one to many join that is causing my problem. here is my data I must gave this problem a lot of time and sear