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 |
|
NickRice
Starting Member
13 Posts |
 Posted - 2003-11-21 : 12:14:31
|
| I have two tables, say table A & B:A.ID A.Name------------------1 AAA2 BBB3 CCCB.RowID B.FID B.Value---------------------------1 1 1112 1 2223 2 3334 3 4445 3 5556 3 666Now, how can I get a resultset as:Name Value----------------AAA 111,222BBB 333CCC 444,555,666Thanks for your help. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
String Concat in Group