I need to generate a list of all integer numbers from 1 to 100,000 inclusive but in a random order.
I understand the random command can be used to generate "random" values but if I generate 100,000 random integer values, this is unlikely to be one instance of every integer value from the range I want.
I could generate a value, check that it has not already been generated and store it or discard it before generating the next value but this seems very long winded.
Could anyone suggest a more sensible way to do this
Any help and forebearance will be much appreciated.
Paul.
RANDOM SEQUENCE
H.Saber
astrogene1000
>>I could generate a value, check that it has not already been generated and store it or discard it before generating the next value but this seems very long winded.
It may be easier to generate the integers sequentially and generate a random "key" for each. Then you could sort the integers using the random key to put them into random order - something like this....
CREATE CURSOR cur_ints ( value_int INT, key_num INT )
FOR lnCnt = 1 TO 100000
lnInt = lnCnt
lnKey = INT( RAND() * 100000 ) + 1
INSERT INTO cur_ints VALUES (lnInt, lnKey )
NEXT
INDEX ON key_num TAG key_num