>To all those trying to use
>select top 1 rand()*1000000 bla bla
>to select one record randomly from a table:
This method is not correct and the result will depend on the physical order of the database. (Because there may be more than one record with the same rand()*1000000 value and you'll take only one of them.) This is not random.
>Vlad
Vlad,
I disagree. Random does not necessarily mean unique. If you want to make sure you do not select the same person, then store the previous winners in a table for comparison. However, unless you can show me a predictable algorithm used by SELECT TOP 1 RAND()*1000000 etc. then it is random.
George
George Simon, MCP