title: selecting individual xml node using SQL
body: <p>I have a large  XML note with many  nodes.</p>
  
  <p>is there a way that I can select only a single  node and all of its contents from the larger XML?</p>
  
  <p>i am using sql 2005</p>