>I am not able to delete the duplicates from the table in SQL. I fiured that if I could generate a unique value for every records in the table that I would then be able to delete the duplicate records and then drop the column I added.
>
>I tried both of these.
>
>select lis_vol.*, RAND( (DATEPART(mm, GETDATE()) * 100000 )
> + (DATEPART(ss, GETDATE()) * 1000 )
> + DATEPART(ms, GETDATE()) ) as random from lis_vol
>
>select lis_vol.*, RAND() as random from lis_vol
>
>They both run so fast that a unique value is not generated. Maybe I will have to export the data to Excel or something.

speed is out of the game. SQL evaluate RAND() one time only, to put aside from the speed.

Question: have lis_vol a primary key ?