I actually want to achieve the following description

This is the table argument I want to pass to the server

<items>
    <item category="cats">1</item>
    <item category="dogs">2</item>
</items>    

SELECT * FROM Item
    WHERE Item.Category = <one of the items in the XML list> 
    AND Item.ReferenceId = <the corresponding value of that item xml element>

--Or in other words:
SELECT FROM Items
    WHERE Item IN XML according to the splecified columns.

Am I clear enought?

I don't mind to do it in a different way other than xml. What I need is selecting values that mach an array of two of its columns' values.