After a bit of research, finally found the answer to how to set up random values for each record in SQL Server:
rand( CAST( NewID() AS varbinary) )
SELECT rand( CAST( NewID() AS varbinary) ) FROM table_name
The reasoning is this:
- Using rand() doesn’t work because it is executed per-query, so you end up with value being the same for all columns
- Using NewID() doesn’t work for me because I need a numeric value
- Using record ID doesn’t work because the result was not random enough… all values were uniformly ordered… seriously…
So I new it had to be something like rand( NewID() ) to get something that looks random… and I found the answer here.