XML Comparison which having attributes in SQL server : I'm having two XML strings in two seperate tables.

**ROOT**

**Node ID=** 1

**name** vignesh **/name**

**street** 1211 **/street**

**/Node**


**Node ID=** 2

**name** ram **/name**

**street** 333 **/street**

**/Node**

**/ROOT**


----------

**ROOT**

**Node ID=** 1

**name** newbie **/name**

**street** 121223 **/street**

**/Node**


**Node ID=** 2

**name** pro **/name**

**street** 445**/street**

**/Node**

**/ROOT**


----------


Please help me to find the comparison between these two XMLs in **SQL** Server and give result as Old value and New value for both ID1 and ID2(Node).


