how to call a stored procedure from stored procedure

check this similar post Call stored procedure from another stored procedure in SQL Server[^]

I am giving few steps to achieve goal.

1. Create a stored procedure for addition two number

CREATE Procedure Proc_AdditionTwoNumber
(
	@first int,
	@second int
)

AS
Begin
declare @add int
SET @add= @first + @second
SELECT @add
end

2. Create another stored procedure that will call first one using exec statement

CREATE Procedure [dbo].[proc_AddTwoNumber]
(
    @first int,
    @second int
)
AS
exec  Proc_AdditionTwoNumber @first,@second

3. call second stored procedure to get result

exec proc_AddTwoNumber 12,30

Use Exec statement inside the calling SP and supply parameters if any, to execute a Stored Procedure in another .

Refer

sql-server-pass-one-stored-procedures-result-as-another-stored-procedures-parameter/[^]

calling-stored-procedure-from-another-stored-procedure-sql-server[^]