Futher to "Kankeyan's" solution above bit more detailed
STEP 1 : Create the fist procedure
create procedure spProcedure1 (@id int)
as
Begin
Select 'Procudure1 id value=' +STR (@id)
End
STEP 2 : Create the second procedure, Second procedure is calling the first procedure within
create procedure spProcedure2 (@id2 int)
as
Begin
Declare @id3 int
Select 'Procudure2 id value=' +STR (@id2)
set @id3=@id2*2
exec spProcedure1 @id3
End
STEP 3: Call the second procedure with a sample paramter
spProcedure2 10
Analyse the output and hope its self explanatory