Re: Merge Multiple Rows Into Single Result
From: Brian E Dick <bdick_at_cox.net>
Date: Thu, 14 Nov 2002 20:43:51 GMT
Message-ID: <bWTA9.1140$0U1.59748_at_news2.east.cox.net>
Date: Thu, 14 Nov 2002 20:43:51 GMT
Message-ID: <bWTA9.1140$0U1.59748_at_news2.east.cox.net>
Use Sybase ASA. It has an aggregate string function called List().
"Niko" <nick_wakefield_at_hotmail.com> wrote in message
news:9da94cd1.0211140835.56fa096b_at_posting.google.com...
> Hi,
>
> Does anyone know a way to do the following, given a table like
>
> Field_A, Field_B
> a first word
> a second word
> a third word
>
>
> then runa group by query on it to merge the contents of field_b
> seperating with commas.
>
> select field_a, merge(field_b,',')
> from table
> group by a
>
> resulting in
> Field_A New_String
> a first word, second word, thrid word
Received on Thu Nov 14 2002 - 21:43:51 CET