August 12, 2016 at 10:22 pm
Hi
I have 2 tables Product , Attribute. In Attribute Table i have 3 fields . I am passing SpecsId as parameter . If SpecsId parameter has 2 values 1,5 then it should return all those products which have both these values. In my case it should return ProductId 1 & 2.
ID , ProductId, SpecsId
1 1 1
2 1 5
3 4 1
4 2 5
5 2 1
6 3 2
7 3 6
If i have database like this how it can be done
1 1 1,5
2 4 1
3 2 1,5
4 3 2,6
Thanks
August 13, 2016 at 1:05 am
Welcome to SSC,
Since we're not at your computer, you'll have to meet us halfway and provide CREATE TABLE and INSERT scripts to populate them. Please read this article "Forum Etiquette: How to post data/code on a forum to get the best help[/url]" so we can better help you.
I've read your post several times and I'm not sure what you're trying to do. Could you please explain?
August 13, 2016 at 8:26 am
Please don't post the same basic question in multiple forums. It only fragments responses and spreads the discussion around so things get lost. Direct replies to http://www.sqlservercentral.com/Forums/Topic1809353-391-1.aspx.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply