Viewing 4 posts - 1 through 4 (of 4 total)
Using the checksum of a newid as the seed in the rand function does work because the newid is reinterpreted for each row. The only time I'd do it was...
July 8, 2014 at 1:59 pm
The only problem is that the rand function returns the same value for each row. Changing the seed value changes the value returned by the rand function, but it is...
July 7, 2014 at 10:29 am
Peso (6/9/2009)
And it's also well established thatABS(CHECKSUM(NEWID())) % 100
gives random numbers between 0 and 99 with very high, good and even distribution.
I like this solution - it is simpler than...
June 10, 2009 at 8:58 pm
Viewing 4 posts - 1 through 4 (of 4 total)