Hey, Mike,

What I've done, and what I believe others have done frome time to time, is generate their stored procs.

So if you have many stored procs that follow the same pattern...

GetAllCostCenters
GetCostCenterByPK
GetCostCenterBy
GetActiveCostCenters

GetAllCustomers
GetCutomersByPK
GetCutomersBy
GetActiveCustomers

etc., etc.

You can generate them from either a script, or even from a .NET app.

As far as having fewer stored procs with many parms....you know what...I really thing it's the old "six, and one half dozen the other"

My two cents...

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313