title: How to filter xml nodes in sql server?
body: <p>How to add second condition to the following query?</p>
  
  <pre><code>SELECT c.value('@tray','VARCHAR(MAX)')
    FROM @L_XML.nodes('/XDOC/DOC[@TYPE="Q"]') T(c)     
  </code></pre>
  
  <p>so that I could filter on attribute: type = Q or S?</p>
  
  <p>Where Can I find a detailed manual about xml nodes?</p>