The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
That is a possibility and why I did not 'fix' it - however it's not a pattern I have seen in any of the code where I work.
A better way of coding for this sort of issue is not to have unnecessary parameters but to have an 'entry point' stored procedure which then decides on which stored procedure to call.
The entry point stored procedure having all the parameters and each subsequently called stored procedure only having the parameters required.
“That which can be asserted without evidence, can be dismissed without evidence.”
Yeah, one of those day. The program didn't happen to store part of the code in database and inject them dynamically, does it. That is exactly what I have to deal with recently.
Luckily I convinced the customer to rewrite the whole thing from scratch in Desktop.
The days of teenagers motivated to pick up an ax and learn a few chords is long gone. They're all playing their virtual games and strumming on their air guitars, if that even. Besides, a good guitar (or any instrument) doesn't have the built in obsolescence that the typical product nowadays.
They're also used to being kept in low- and no-stress situations. So, having to actually do something - by that I means, something real - means they might not get immediate success. Or ever achieve success at all. It's better to just make sure the earbuds fit snugly.