Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Joining values into a single varchar string
Message
From
07/03/2003 14:41:54
 
 
To
07/03/2003 13:56:17
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00762903
Message ID:
00762946
Views:
12
It is very very very very hard to do and works best when you have a fixed number of items or at least a maximum number.

In my experience, this type of manipulation is better off being handled by something outside of the database.

-Mike

>I have a parent record with 0-n child records. The child records contain a field that I want to combine all the values into a single comma delimited string. I want to run a SQL7 query that will choose the parent record once and create the comma delimeted string as a field in the result set instead of choosing the parent record repeatedly for each child record. Is there any way to do this with SQL only, i.e.:no stored procedure?
>
>Thanks in advance for any help with this.
>
>Don
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform