I try to minimise code by creating new stored procedures that can be called from more than one other SPROC.  So, sometimes, less code but more SPROCS are the answer. 

In my current application I have created what I call twin SPROCS.  These are identical except for the substitution of one table name with another in the select statement used for an insert.  Should I find a way of not doing this?  Can I have conditions in the code that would enable an alternative approach.  Maybe I should consider using the the 'when' command or something.