使用SQL Server上另一个XML的节点更新XML列

I have two tables with 1-M relationship, both containing XML columns. I have to update an XML in second table's column from another node from first table's XML's node. After struggling with the syntax to get it work, I have finally been able to get it to work. However, it is still not working. I see the rows getting updated in the messages tab but when I select the values from second table, nothing is updated. Here is a sample of my TSQL code:I have two tables with 1-M relationship, both c