T-sql查询在xml的所有节点中包含属性值

Hope you all are doing good. i am having a requirement that i want an sql query to include attributes value in all the nodes of the xml. in the below script ID value should come in all the node as attribute .Sample code and try for your reference.Hope you all are doing good. i am having a requ