Can we call Stored Procedure in Other Stored Procedure???

Hi,

yes it possible, but make sure that you dont cross the nested level of the stored procedure. the nested level is 32.

Thanks --Vj

Hi !!

This is possible and simple as well.

you have to write Exec provedure name and write the parameter value to pass into the second procedure.

that's it.

You will get the second SP executing inside the First one.

Yes it is, as long as the user that is logged in has access to the stored procedure being called within the stored procedure.
Simply 'exec' it within the stored procedure.