SQL - Is this even possible ?

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. Received on Thu Mar 13 2008 - 10:26:42 CDT