Does anyone knows about best practices for nested calls in store procedures?
An example:
SP_1(PARAM1)
{
Do something;
}
SP_2(PARAM2)
SP_1(PARAM2);
SP_3(PARAM3,PARAM4)
SP_2(PARAM3);
SP_2(PARAM4);
is or isnt a good practice?
THANKS.