Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-25 : 08:50:32
|
| Nilabdhi writes "Hi!,I have a lottery system in which , there are around 75 prizes and the prizes are selected randomly from the record......I have one of the columns as Id the Id column sequentially increases from 1 to 75. So as and when one random number is generated using the 'Rnd' function on the records of Id column...after 'Randomize' one row is displayed and deleted and the next random number is generated from the remaining records.eg.. after first run the random number is generated from 74 records after second run it is generated from 73 rows and so on... but once it decreases to around 10 or lesser rows it gives sql...error....Why is it so.....? Its same for MS Access too....Is it same for all microsoft database products or is there any solution...?Thanks & Regards,Nilabdhi" |
|
|
|
|
|
Random Number Error after Records decrease below 10