Hi,

Does anybody know what the syntax is for executing a stored procedure from within another stored procedure?

IE. execute SP2 inside SP1

Many thanks in advance

hi,
you can call an SP from within another SP just like calling it from MySQL client. but instead of passing session variables as SP parameters you can use local variables that have been declared in your parent SP.
just call your SP like this: Regards
Chagh