General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only