How can I make a multi search SPROC/UDF by passing a tabled-value to it?
- by Shimmy
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.
