I'm not familiar with these but I will take a look. Thanks for the link!

Hahaha! Thanks! Yeah, the whole system was written by a junior programmer. I have lots of areas to re-write so I was hoping I could just quickly add the missing...

I apologize! In my effort to make a quick script for the purpose of asking my question, I left out the reasoning behind the script.

In this case, there is a...

Thanks for the optimization help! 🙂

As for the results, I'd like them to look like this attachment...

Thanks so much for your help with this! I'm a seasoned programmer but never had to do much T-SQL programming beyond simple joins.

To see how I'd like the results to...