call procedure inside another procedure

CREATE PROCEDURE Sp_insert
(
@ID INT,
@TempName VARCHAR(MAX)
)
AS
BEGIN
DECLARE @SampleTable TABLE(id INT, Name VARCHAR(MAX))
INSERT INTO @SampleTable(id,Name)VALUES(@ID,@TempName)
SELECT*FROM @SampleTable
END

Here IS my SECOND stored PROCEDURE.

CREATE PROCEDURE Sp_Call
(
@SID INT,
@Name VARCHAR(MAX)
)
AS
BEGIN
EXEC Sp_insert @ID=@SID,@TempName=@Name
END
FROM t