Okay, thanks.

Thank you all for your input. I think I can safely say that I would be speaking for all users of this site when I say I am very appreciative...

Gail,
Again, so that I am clear, the best solution for our situation is:
Sunday - Full, Monday - trn, Tuesday - trn, Wednesday - trn, Thursday - trn, Friday...

To expand: We have three databases that are hosted by a company that is offsite. We also have two onpremis servers that have copies of these three databases. We use...

Thank you SSCrazy.

I was able to adapt your code to what I was attempting to accomplish and it worked. I've been fighting with this for quite some time now and...

Well, I'm embarrassed. The problem was in my code and how it was, or actually was not, handling NULL values. Once I put in an ISNULL statement the problem was...

Thank you for all of your input.

I recently learned that the days that I must gather data for is for the last 5 school days. All days that had...