Updating duplicate data

Last Post 17 Jan 2008 09:27 AM by trans53. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
17 Jan 2008 06:09 AM
Hi,

I have about 40K rows with the same lastname, firstname combination in the table and was wondering if there any way to randomize this data. Data must be unique as much as possible.


Deleting duplicates is not an option in this case.

It is possible to do that?
nosepicker
New Member
New Member

--
17 Jan 2008 09:16 AM
If you don't care what the data actually is, you could also make use of newid().
trans53
New Member
New Member

--
17 Jan 2008 09:27 AM
Thanks a lot guys
You are not authorized to post a reply.

Acceptable Use Policy