Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Warren Getting Random Results RE: Getting Random Results
RyanRandall
SSChampion
Points: 13623
More actions
August 23, 2007 at 8:36 am
#728967
Using "ORDER BY CHECKSUM(NEWID())" rather than "ORDER BY NEWID()" apparently produces values with a better random distribution.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.