Test data. Even if using live data, reduce the throughput of what is being processed, so you can make reasonable assumptions about what should/should not be changing at any point,...

Steve - anyone can add a topic to the Editorials forum? Why? And also, this unprofessional topic got posted there (why someone would put this out there is beyond me)

Is it a context issue? Blind guess, but perhaps you're not fully qualifying the name, and so it's looking in master on the deployed version, while your local one knew...

posting a follow-up to say that if you're going to group by month a lot, you might just want to create a permanent date table, so you don't have to...

You did a good job of providing what you've tried, it's helpful if you put your sample data into a temp table script too. Here's one way, had to handle...

anyone who is making decisions that affect personnel (hiring/firing/writing someone up/even just having a conversation with HR about an incident) needs to have a door. period.

The thing...