We all know SQL is not really great for running totals, but two things it does outstandingly well are summary queries and looking stuff up. Your percentage calculations...

Griff, since nobody stepped up, I will ask a couple of questions. I don't think you require floating point operations here, but how do you define best? ...

Mega pita bites?

Is that like a pita bite?

Only one ??

Not strictly true, Barry 😉

Yes, Paul. But it's nothing a little creative dyslexia can't handle. 😀

Busy with life is a good thing. Thanks Grant and Steve.

Lynn, I will go read it now.

Chicks dig scars.

Did anyone ever say where Gail disappeared to?

... unless you are adding additional logic within the procedure itself.

Fair question. The problem is that the sample data included no ties, so you never see a difference in behavior. Check out the example below. ...

I have season tickets to Ole Miss home games, Steve 😉

Hmph... you probably are a fan of the hated Carlton Blues.

Got both emails, Lynn. Thanks for taking the time and trouble.

I'm doing well, and hope the same goes for you.

It must be those cute little green ears, Lynn 😀

For the benefit of posterity, I will guess that I am "Chernobyl" because my current avatar is a fiery red biohazard...