In other projects, the priorities could be different, but in my project, top priorities are
#: Can boss tolerate such copy-paste? yes
#: how much time is given for this project? enough for A or B.
#: how much time is given for this project? enough for A or B.
#: [A] even if you have enough time, should u spend the extra time here or on other areas?
#: [A] regression test effort
#: [A] integration test effort
#: [A] readability
#: effort during subsequent code changes — Just copy the changes over into the new sp
Change is frequent. future changes by other people may disfigure your design.
Plan A: copy paste the common code blocks into a self-contained new sproc.
Plan B: modify existing sproc to call a new sproc, so as to avoid copy-paste.
Considering all the priorities, the cost-benefit of Plan B is questionable.