Re: SQL - Is this even possible ?

"Shakespeare" <whatsin_at_xs4all.nl> schreef in bericht news:47d992b6$0$14354$e4fe514c_at_news.xs4all.nl...
>
> "marfi95" <marfi95_at_yahoo.com> schreef in bericht
> news:f835a4bd-5ecd-4e5d-b574-f11f15949e8e_at_n75g2000hsh.googlegroups.com...
>> Hello,
>>
>> Is it possible given the following rows in a resultset to produce a
>> merged resultset as shown below.
>>
>> Key1 Col1 Col2 Col3 Col4
>> ------------ --------- -------------
>> ---------- ----------
>> 1 A 1
>> 1
>> B 2
>> 10 C 3
>> 10 C 4
>> 10
>> D 3
>> 10
>> D 3
>> 18 F 5
>> 18 F 6
>> 18
>> G 5
>> 247 H 7
>> 247 H 8
>> 247
>> I 7
>> 247
>> I 9
>> 247
>> I 10
>>
>>
>> Need it like this:
>>
>> Key1 Col1 Col2 Col3 Col4
>> ------------ --------- -------------
>> ---------- ----------
>> 1 A 1
>> B 2
>> 10 C 3
>> D 3
>> 10 C 4
>> D 3
>> 18 F 5
>> G 5
>> 18 F 6
>> 247 H 7
>> I 7
>> 247 H 8
>> I 9
>> 247
>> I 10
>>
>>
>> Basically, I'm just trying to merge rows together based on key1.
>>
>>
>> Any help is greatly appreciated.
>
> Look about 20-30 rows down in this group.Title: Consolidation of multiple
> rows.
>
> Shakespeare
>

But stop reading after 10 or so posts ....

Shakespeare Received on Thu Mar 13 2008 - 16:54:56 CDT