How to Populate Random Data

[sconti11]

I am trying to build dummy data to be used for a presentation, and made a mistake with one table when I ran an UPDATE statement and changed 58K rows to one description.

Does anyone know how to write a statement where I can update those 58K rows with random data?...Basically I have 180 distinct values that I need to insert over the value that is in there, but I need to retain the total number of rows.

Hopefully that makes sense.

 

[sparkbyte]

Take a look here.

http://stackoverflow.com/questions/1468159/how-can-i-insert-random-values-into-a-sql-server-table

Thanks

John Fuhrman

 

[sconti11]

Great Help!...

Keep up the awsome assistance!