Execute a stored procedure in another stored procedure in SQL server
// procedure 1
BEGIN
DECLARE @Results TABLE (Tid INT PRIMARY KEY);
INSERT @Results
// call procedure 2 from procedure 1
EXEC Procedure2 [parameters];
SET @total 1;
END
SELECT @total