Link to home
Create AccountLog in
Avatar of BananaFury
BananaFury

asked on

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
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

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.
hmm, how should that work at all: I need to select some random records using the following criteria??
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of BananaFury
BananaFury

ASKER

Thanks very much for your help, most appreciated!
???

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