Quick question please.
Once huge sproc with 7 INSERTS OR 7 separate procs and one to call them all.
This is my preference: 7 separate sprocs each with just one INSERT code (easy to manage and pinpoint failure, can be run separately etc)
what are your thought? One proc or seven
your input is greatly appreciated