I want to do an automatic computer drawing for certain people, I puted all the records in a cursor including how many times they have a chance to win, each chance is a seperate reocrd, what is the best method that it should pick random records ?, I worked with RAND(), I added a numeric field named no then I did
RAND(-1)
REPLACE ALL no WITH RAND()*1000
then I did select top 1 from cursor order by no
Can anyone advise me if with that way is it really random so I can be sure that the drawing is fare ?
Any help will be greatly apriciated.
Simon
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement