I have a table which has duplicate values within it. I now need to put a primary key on this column, but obviously am unable too. Can anyone give me an idea on how I can achive this without losing the data and also to be able to put a primary key on it.

Something like copying to a temp table etc etc

Thanks in advance


Marlon..