Redesign your table(s).  Best suggestion I can give, especially since we know nothing about your system.

Looks like 1st place could easily be on the line this week.  Look at the contest between the other undefeated team.

"On any given Sunday!"

Well, this weekend looks to be a good one.  Two of the three undefeated teams are going head to head.

"On any given Sunday!"

Well, just a guess but I would say you have a table with quite a few variable length columns that if you added up the maximum size of each column...

My Google-Fu is failing me.  Does anyone know where I may find information comparing text comparisons vs numeric/binary comparisons?  Looking for performance information while working on some SQL tuning.

I would convert all the dates to the first of each month and group on that value.  No parsing and concatenating of values required.

dateadd(month,datediff(month,0,Datecol),0)

I may have won my 2nd game, but looks like the Bulldogs will take the top spot in the Bulk Logged division.

And, yes Jeff, I will be there since I am one of the directors of the Colorado Springs User Group.  I sort of have to be there.  Whether or not...

Time to start planning for SQLSaturday #700 in Colorado Springs, CO next year!!

Would also be nice if you could show us what you have done so far.

Started documenting the issues of the current code and the requirements for a rewrite.  Managed to rewrite a segment of the existing code using the DRY principle.  The OUTPUT clause...