title: pass list of int's as xml to be used with where clause
body: <p>I am sending the following xml to a sql server stored procedure to be used in a where clause.</p>
  
  <pre><code>&lt;root&gt;
   &lt;id&gt;1&lt;/id&gt;
   &lt;id&gt;2&lt;/id&gt;
   &lt;id&gt;3&lt;/id&gt;
  &lt;/root
  </code></pre>
  
  <p>I am trying to work out a way to have a select statement where the where clause will check for any of the id values in the passed xml parameter.</p>
  
  <p>Something like this:    </p>
  
  <pre><code>@xml xml
  select * from table
  where (if exists (select id in @xml))
  </code></pre>
  
  <p>sorry i am not very good at sql.</p>