Help with query

Hello

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

thanks

Microsoft SQL Server

Last Comment

ste5an

8/22/2022 - Mon

Jim Horn

4/24/2015

Two things:

Give us a data mockup, both sample data and expected output, of what you're trying to pull off here. The description is not very intuitive.

I recommend renaming this question to something more descriptive of what the question is, as 'Help with Query' is not going to attract all experts that can answer your question, and doesn't help future experts searching for their own answers.

Thanks in advance.

ste5an

4/24/2015

hmm, how should that work at all: I need to select some random records using the following criteria??

ASKER CERTIFIED SOLUTION

Scott Pletcher

4/24/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

BananaFury

4/25/2015

ASKER

Thanks very much for your help, most appreciated!

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

ste5an

4/25/2015

???

SELECT TOP 10 PERCENT *
FROM	sys.objects
ORDER BY NEWID();

SELECT derived.*
 FROM (
     SELECT *, ROW_NUMBER() OVER(ORDER BY NEWID()) AS row_num
     FROM sys.objects
 ) AS derived
 WHERE row_num % 10 = 1

Open in new window