Append varchar columns from multiple rows?

[nacrotek]

Is there a way to concatenate all the varchar values in a result set? I'm looking for an aggregate function that I could use with a group by.

Say I've got the following data.
ID FK Comment
1 1 Some string value
2 1 Some other string value
3 2 Some usefull bit of whit

and I want the following as output:

FK AllComments
1 Some string value Some other string value
2 Some usefull bit of whit


Thanks for any help.

 

[mrdenny]

Your best bet would be to do this in the user interface. There are lots of examples in the threads on this in the forums.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[amrita418]

There are several ways to handle this. If the number of records per id are less (around 5-6 maximum) then use the max(case...) logic else create a function.

Check [link thread183-1129808] this [/url] thread for details.

Regards,
AA