Information générale
Forum:
Microsoft SQL Server
I kind of figured as much. I was just hoping someone might have an idea how to do this.
Thanks anyway.
Don
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement