Aggregate function for strings

[ryanxr]

Hi,

I'm trying to concatenate string values from the same field in different rows. I'd like to do something similar to the sum function with a group by criteria.

For example, if my initial table looks like this:

CASE_ID SUMMARY
------- -------
15001 Text
15002 Text
15003 ABC
15003 DEF
15003 GHI
15004 Text

This should be the result:

CASE_ID SUMMARY
------- -------
15001 Text
15002 Text
15003 ABCDEFGHI
15004 Text

Thanks!

 

[blom0344]

This would be a case for a stored procedure that loops through the records and uses a cursor. As long as the next CASE_ID is the same than do a concatenation of the summary value.
Any possible solution with just SQL will become VERY slow with more than just a small dataset....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[ryanxr]

blom, thanks for the info. it is a big dataset so i'll have to figure out something else. cheers.