Loading

Stored Procedure

srinath

15y1.8k

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter PROCEDURE proc1
@in1int
AS
BEGIN
SET NOCOUNT ON;
exec proc2 @in1
END
GO

----------------------------
----------------------------

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter PROCEDURE proc2
@in2int
AS
BEGIN
SET NOCOUNT ON;
select (@in2 + 100) "out"
END
GO

-----------------------------
--exec proc1 300