Stored Procedure

Question

Hi I am using sql server 2008. I have a stored procedure in a stored procedure Here I want to use the output of child stored procedure in the parent stored procedure so that I can perform certain operations using that output. I tried but I couldn't. Please help me

Suthish Nair · Answer

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter PROCEDURE proc1 @in1 int AS BEGIN SET NOCOUNT ON; exec proc2 @in1 END GO ---------------------------- ---------------------------- SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter PROCEDURE proc2 @in2 int AS BEGIN SET NOCOUNT ON; select (@in2 + 100) out END GO ----------------------------- --exec proc1 300