I am sure this is a relatively easy one for you guys.
I need to select some random records using the following criteria
First I need to count the files that were closed last month. I have a closed date. This number will be X
Then I want to take X and divide that number by 20, this number will be Y
Then I want to run a counter down my table, resetting at Y.
Then I will pull out all rows where the counter = 1
Does this make sense, and what is the easiest way of tackling the task as I have been exporting chunks of data and manually manipulating the files, but ideally I shouldn't be that involved in the selection