Think of it the same as OOP. Each method should have one function and one only. So, you should have three stored procs.
>Hi everyone,
>
>We're having a discussion with my colleague about should we use 1 procedure for INSERT/UPDATE/DELETE and just pass action parameter or 3 separate procedures.
>
>I'm saying 3 procedures are better and he is saying 1 procedure is better from the maintenance point of view.
>
>I would appreciate PROS/CONS for either of the opinions.
>
>BTW, where is Walter? Haven't seen him here for some time.
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer