title: Where clause on a SQL Server XML column filtering on attribute AND value
body: <p>I have a 'Metadata' field in table 'Document' that has the following data:</p>
  
  <pre><code>&lt;properties&gt;
    &lt;property name="someProp"&gt;xyz&lt;/property&gt;
    &lt;property name="reportId"&gt;55&lt;/property&gt;
    &lt;property name="someOtherProp"&gt;abc&lt;/property&gt;
  &lt;/properties&gt;'
  </code></pre>
  
  <p>How can I write a query that returns records where a property element exists with a name of "reportId" and that "reportId" property element has a value of 55? Sometimes the "reportId" property node is the only one that exists, sometimes not, and it's not always in the above order so I can't query on absolute positions.  Any ideas?</p>