Re: Merge Multiple Rows Into Single Result
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 14 Nov 2002 17:04:00 GMT
Message-ID: <3DD3D77C.FD124E08_at_exesolutions.com>
Date: Thu, 14 Nov 2002 17:04:00 GMT
Message-ID: <3DD3D77C.FD124E08_at_exesolutions.com>
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 - 18:04:00 CET