• is this a better choice guys? RAND(checksum(newid())) ?

    perhaps because it increases randomness by not allowing dupes between negatives and positives? Perhaps also because none of us really knows if the combo of newid and checksim is as random as rand?