I have a table with contains multiple rows that define \"amenities\" for a particular resort. I need to return the resortID if there are rows containing whatever \"amenOptionID\" I define. My issue co
I have a Database storing details of products which are taken from many sites, and gathered through the individual sites API\'s. When I call the feed, the details are stored in a database table.
A co-worker posed this question to me, and I told them, \"No, you\'ll need to write a sproc for that\".But I thought I\'d give them a chance and put this out to the community.