A SQL challenge

therealbrandonwilson  •  17 Nov 2026   •    
Screenshot

I was assigned a ticket today that has been unexpectedly challenging. Someone at the client is requesting a report with a specific category of codes. I understand what she is asking for, but pulling it from the system is quite challenging.

The issue is translating the data she wants into how the system stores it. As system analysts, we usually start with paper requirements and interpret them so they can be configured in the system. I'm essentially going backward from the system build to requirements documentation. The easy answer is to pull the data and send it over, but I know that won't help with what they are looking for. That's what makes me different from a typical IT person; I understand operational requirements.

So I spent most of today designing the query, and then I'll have to put together some more wizardry in Excel for the final report. I've used Copilot a couple of times, and I should have a draft for review tomorrow. I wonder who else at the client could perform this analysis and provide the deliverable that I will provide. I guess that is why they still retain consultants with unique expertise to handle these requests.

 

Comments


Competence. It’s how you win extra work.

Winkletter  •  17 Nov 2026, 9:58 pm

Discover more

Sourced from other writers across Lifelog

Ooops we couldn't find any related post...