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.