I figured out the problem. There are 10 duplicate records in the table. Now I need to figure out how to delte duplicate records.

I have to get a unique value added to a new column in the table.

I tried Rand() but the select statement happens too quick.

select lis_vol.*, RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )

Any suggestions?