Regarding NestedStored procedure
Is it a good practice to have nested stored procedures (meaning Stored procedure inside another Stored procedure). Are there any precautions that one should follow while nesting Stored procedures. Is there a permissible limit on how many one can nest inside.

Thanks in anticipation

 
Regarding NestedStored procedure
===

Is it a good practice to have nested stored procedures (meaning Stored procedure inside another Stored procedure). Are there any precautions that one should follow while nesting Stored procedures. Is there a permissible limit on how many one can nest inside.

Thanks in anticipation

 