Re: Merge Multiple Rows Into Single Result

Niko wrote:

> 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

Given that you are the second person in as many days asking the same question I can only presume that this is a class assignment ... so you will need to figure it out yourself.

Hint: It requires a cursor and a loop.

Daniel Morgan Received on Thu Nov 14 2002 - 11:04:00 CST