Update with random number
Posted on 2013-02-06
I would like to randomize values in a table.
The table we call MainTable It has columns UserId, Username, ColM (int).
Then I have another table with the random values.
The table we call PoolTable. It has columns Id, PoolCol (int)
I would like to find random values for each UserId. I would like to replace ColM with the value of PoolCol.
Id=1, UserName="John", ColM=5
Id=3, UserName="Howard", ColM=5
One example of result could be
Id=1, UserName="John", ColM=73
Id=3, UserName="Howard", ColM=55
How is best to do this?