Environment sql server 2005 My question is
Calling a stored proc within a stored proc within another stored proc. When is this type of development detrimental?
In order to promote code reusablity we have encapsulated various insert/update statements into stored procedures. So if want to insert A Foo record then you would pass the parameters to the CreateFoo stored proc and go about your day.
Well lets assume a Foo object needs to Create A Bar objects which also Creates a Mark object.
Thus your stored proc will call the foo stored proc which will then call the bar stored proc which will then call the mark stored proc.
When is this not a good idea, and what are my other options. Thank you very much. If you could, could you put the sources that back up your answer. Again thank you very much.