Write a store procedure to run other store procedure.

Create a root sproc
@param1 int

as
begin
if condition
begin
exec sproc1 @param1
end
else
begin
exec sproc2 @param2
end
end

In the above examples, all the store procedures must have the same input parameter.
You can execute it any matter and conditions you want.
It is an SQL query od store procedure to run other store procedures.