I want to generate X number of unique random numbers in a range and insert those numbers into a new table The number of samples "X" will be defined when entered into a field of a table.
at the moment I have
SELECT Int((End_Sample_No-Start_Sample_No)*Rnd()+Start_Sample_No) AS RandNum
I am stuck on working out how to making more than 1 random number and ensuring that if I do make more than one it is not already used.
Any suggestion or direction is appreciated.
Aucun commentaire:
Enregistrer un commentaire