title: How do I append / merge additional XML into an existing XML field in SQL Server 2005
body: <p>I have a column in SQL Server 2005 that stores a simple chunk of XML.  At a later point processing is performed and I need to merge some processing info into the XML.</p>
  
  <p>While I can do this at an intermediate point I would much prefer to keep this method centraliazed within the stored procedure that is responsible for updating other fields post-processing.</p>
  
  <p><a href="http://paste-it.net/public/d7d8ab3/" rel="nofollow noreferrer">Here's an example</a> of the XML I'm starting with and the type of outcome I'd like to achieve.  Can anyone provide me some rough SQL to achieve it?</p>
  
  <p><strong>Update:</strong> Finally got it!  I'll post the full solution when I get the chance, it was enough of a hack that someone else will hopefully find it useful</p>
  
  <p><strong>All finished!</strong> In the end I had a couple of additional requirements that required me to rework Marc's suggested solution and ditch the .modify() function entirely; however his answer let me get past my initial hurdles and got me to where I could step back and spot the easier approach.  <a href="http://www.paste-it.net/public/ue339b1/" rel="nofollow noreferrer">Here's my final solution</a>!</p>