Hi All,

I have the following table with 4 columns and 6 rows.

A B C NUMBER
X Y 234
     Z 234
     K 235
R 236
     M 237
L 237

I am trying to create a new table that eliminate the duplicate data under the "NUMBER" field. Here is the table that I would like to see after eliminating the duplicate data.

A B C NUMBER
X Y Z 234
         K 235
R 236
L M 237

Any help would be appreciated, thanks...

Tell Me,
What will u do when data will be like.
A B C NUMBER
X Y 234
   S Z 234
        K 235
R 236
        M 237
L N M 237

Or Many More.....


Enjoy!
Subodh Kumar
Phoneytunes.com

insert into NEWTABLE
select distinct '','','',NUMBER
from ORIGINALTABLE

Update NEWTABLE
SET N.A = O.A
FROM NEWTABLE N,ORIGINALTABLE O
WHERE O.NUMBER = N.NUMBER
AND O.A <> '' AND O.A is not NULL

Update NEWTABLE
SET N.B = O.B
FROM NEWTABLE N,ORIGINALTABLE O
WHERE O.NUMBER = N.NUMBER
AND O.B <> '' AND O.B is not NULL

Update NEWTABLE
SET N.C = O.C
FROM NEWTABLE N,ORIGINALTABLE O
WHERE O.NUMBER = N.NUMBER
AND O.C <> '' AND O.C is not NULL


syntax mightn't be 100% correct but you should get the idea.