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 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2004-09-08 : 16:40:27
|
| I have a problem, which I can explain but am struggling to translate intoSQL syntax.myTable has 3 columns, with some example valuesID NAME NUMBER_ITEMS1 john 42 tim 33 john 24 tim 15 roger 66 roger 7Essentially, I am trying to derive every possible combination between NAMEand NUMBER_ITEMS , but as a set.The set being "john,tim,roger".which conceptually become the columnse,g JOHN TIM ROGERcombination1 4 3 6combination 2 4 1 6combination3 4 3 7combination4 4 1 7Ultimately, I just need them as a coma delimited string. But , mostimportantly I need to be able to get past STEP 1ThanksJack |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
comparing every record in a recordset