Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:19:49
|
| Don writes "Ok here is my problem... I have 3 tables - Products, Options, and OptionChoices. The basic layout of the table is Products contains Basic Product Info, Options contains the names of Product Options, like Color, Size, etc. and OptionsChoices contains the choices for the Options like blue, red, etc. for color. I also have a table ProductsOptionsChoices that links Products with all of their OptionChoices. I would like to return a recordset of strings containing all combinations of optionchoices for a product such that each string contains only one instance of each option. For example color=red&size=xlcolor=blue&size=xlcolor=red&size=lcolor=blue&size=lcolor=red&size=mcolor=blue&size=mcolor=red&size=scolor=blue&size=sAlso note that the number of options a product has is a variable." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-10 : 19:44:31
|
| To be sure...Can you post some sample data and table design? |
 |
|
|
|
|
|
Combinations in multiple linked tables