is improved some-more targeted stored way fewer parameters?

say i have stored way advantage information name query. i rather opposite cut those law depending parameters i pass through. i'm wondering presumably improved settlement have churned stored procedures take parameters (for example, getxbydate getxbyuser), stored way churned parameters does lot (for example, getx)?

the advantage initial choice it's easier maybe faster, nonetheless rubbish idea query repetitious opposing stored procedures needs reliable several places.

the advantage second choice query wholly donation once, nonetheless rubbish query some-more challenging harder troubleshoot.

what your solutions why?