This seems to be the simplest way. I can add a field containing a
random number plus the record number and use a logical over it.
On Mon, Jun 4, 2012 at 12:21 PM, Nathan Andelin wrote:
We have a couple procedures which are based on the CEERANO api;
one to generate random numbers, another to generate random strings.
Do you have a field in your 12 million record file for storing a
random value? If not, consider generating a new table with one
column containing a random value, and another field containing a
sequential number representing the record number of the other
Albert York on Monday, June 4, 2012 12:58 PM wrote:
I have a file that contains around 12 million records. I need a
way to randomize the order of the file in the most efficient
method. Does anyone have any ideas?