Home Forums Article Discussions Article Discussions by Author Discuss content posted by Chris Nowicki Random problems RE: Random problems
christian_nowicki
Valued Member
Points: 54
More actions
June 10, 2009 at 8:58 pm
#1007760
Peso (6/9/2009)And it's also well established thatABS(CHECKSUM(NEWID())) % 100gives random numbers between 0 and 99 with very high, good and even distribution.
Peso (6/9/2009)
ABS(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 the one I proposed.