Apr 30, 2012 02:12 PM|2177|LINK
Create a new wrapper proc. This proc can call all your 4 procs based on some conditions you may want to apply. So the proc will return DataSet and in code you can do whatever you want to with this DataSet.
This way all you need is just call the wrapper proc from the code.