I know, it was a joke. Totally kidding.

I'll try that query out today and let you know how it goes.

-heather

Okay, boys - behave! I know I'm cute, but I won't have you fighting over me. hehe.

I appreciated all the responses. Got a lot out of the answers. Thank you to everyone who took the time to help me out!

-Heather

Remi, I've actually been thinking about doing something very similar... interesting approach - thanks!

Unfortunately I can't do that in this case, because I need the top percent to be done within the groupings - so I need the top 90% of records...

That's also a possibility. Because I have 8 million records and I need to grab different slices of percentiles per state, I'm just going to create a few additional...

I know I can use a subquery to get the top 90% of records from a single state and then perform my state summary calculations from there. I was...

Thanks, guys.

The good news is, I only have to do this once.

Hmm, interesting. To make it more clear, what I have is an enormous table of records (over 8 million to be exact) that contain records on every state in...

Thanks, Farrell. I had a feeling that would be the answer!