calling a stored procedure

[nnmmss]

can i call a stored procedure inside another stored procedure?

tahnks

 

[earthandfire]

Yes

 

[nnmmss]

can you give a sample?
is this ok?
CREATE PROCEDURE CheckPRF @projId int,@TodayDate varchar(20) AS
call SecStored (@projId,@TodayDate)
Go

CREATE PROCEDURE SecStored @projId2 int,@TodayDate2 varchar(20) AS
print projId2
print TodayDate2
go

 

[earthandfire]

>> call SecStored (@projId,@TodayDate)


EXEC SecStored @projId, @TodayDate


Hope this helps.

 

[TysonLPrice]

Needs cleaned up a little but works:

CREATE PROCEDURE CheckPRF (@projId int,@TodayDate varchar(20)) AS
exec SecStored @projId,@TodayDate
GO

CREATE PROCEDURE SecStored @projId2 int,@TodayDate2 varchar(20) AS
print @projId2
print @TodayDate2
GO


From Query Analyzer:

CheckPRF 2222,'01/01/2006'

 

[nnmmss]

and what if i want to have an output back from the SecStored to the CheckPRF ?

 

[earthandfire]

Using the above example:

ALTER PROCEDURE CheckPRF @projId int,@TodayDate varchar(20) AS
declare @Result varchar(100)
exec SecStored @projId,@TodayDate, @Result output
print @Result
GO

ALTER PROCEDURE SecStored @projId2 int, @TodayDate2 varchar(20), @RetVal varchar(100) output AS
print @projId2 
print @TodayDate2 
set @RetVal = 'Fred'
GO


CheckPRF 2222,'01/01/2006'