I'm picking France. The Croats were a little dirty, though I guess France was. Mbappe is something though

Also, it's not all code. You can do

CREATE PROCEDURE myproc
AS
BEGIN
  WITH cte
  AS
  (
  SELECT *
  FROM dbo.SomeTable

Or...

FWIW, I'll be at
- Louisville
- Baton Rouge
- Oslo
- Cambridge
- Pittsburgh

Probably all for me. Maybe Lincoln since it's so close.

Yeah, that's bad. Anyone joining EAV to other tables regularly have issues. If you use them sparingly, EAV makes sense.

I feel for you, that's a bad design. If...

Interesting idea. I'll kick it around.

Since Ken is on vacation, I'm uploading the key.

You haven't grouped by hour, but by time.

Please read the discussion and look at the answers, you need to group by hour.

Excellent. Looking forward to it.

Could we leave the politics out of this. Whether you like the EU Parliment, US Congress, reps, etc., that's not relevant to the idea of adhering to or dealing with...

Great point, Drew. In that case, you might want to build a calendar table of hours and join back. I might even want to do this from the start, since...