Hi,

I'm not going to write the query for you, but will point you in the direction of good documentation on how to update the values in an xml fragment, or xml column...

See the following entry in BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/c310f6df-7adf-493b-b56b-8e3143b13ae7.htm

Good luck!