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 - 2001-04-16 : 00:20:55
|
Thomas writes "i have a complex database for the web with a table and 5 relatiosn to tables (n:m) with categories/subcategories, areas (where more than one may be selected)
i need to have a query where all the detailresults are listed verticaly in a field and not a record for every detail:
actualy it is:
main detail1 detail2 detail3
1 5 7 3
1 5 7 4
1 5 8 3
1 5 8 4
1 5 9 3
1 5 9 3
1 6 7 3
1 6 7 4
1 6 7 4
....
..
and i need to have :
main detail1 detail2 detail3
1 5,6 7,8,9 3,4
is it possible with only SQL, maybe with stored procedure and the option to select the delimiter ( ",")?
thanx
Thomas" |
|
|
|
|
|
subquery returning all records in one string with delimiter