barbraquestxz
New Member
I am getting xml data via web service \[code\]<ITEMS> <item id="uilldmduw"/> <item id="wl2323ldsaw"/></ITEMS>\[/code\]I need to compare this list to the 'items' table on my data base and return only rows that have an id that exist also in one of the xml nodes.XML can contain few hundreds of nodes, items table contains 100k's of rowsWhat will be the best approach