Create a Random sort based on the Record ID#
I have a table which will have 40,000 records loaded and flushed out each day. So it will have a high number with 6 or 7 digits for the [Record ID#] in a few days once we go live. Is there an easy...
Forum Discussion
I have been th8nkimg about this.
My current plan is to take the Record ID, divide by a prime number, then take the first 5 digits after the decimal. That should give me a number between 0 and 99,999 to use as my sort. I�m not sure if it matters what prime I divide by, but maybe a prime of at least 4 digits.
https://en.m.wikipedia.org/wiki/List_...
My current plan is to take the Record ID, divide by a prime number, then take the first 5 digits after the decimal. That should give me a number between 0 and 99,999 to use as my sort. I�m not sure if it matters what prime I divide by, but maybe a prime of at least 4 digits.
https://en.m.wikipedia.org/wiki/List_...