Return Parameter from Transact SQL Stored Proc

[DavidPike]

I am using the folowing CREATE, SET and RETURN statements but nothing is returning from my proc, any tips?

CREATE PROCEDURE dbo.sp_ReplicateChildSchedule
@P_Child nvarchar(50),
@P_WeekToCopy DateTime ,
@P_WeekBeginDate DateTime,
@P_Msg Varchar(50) OUTPUT
AS

SET @P_Msg = '0 schedules replicated'

RETURN

 

[gmmastros]

How are you calling this procedure? I just ran a quick test, and it does appear to be working for me.


Using your procedure above, I can run the following code and get the message output.

Declare @OutputMessage VarChar(50)

Declare     @P_Child nvarchar(50),
    @P_WeekToCopy DateTime ,
    @P_WeekBeginDate DateTime

Exec dbo.sp_ReplicateChildSchedule @P_Child, @P_WeekToCopy, @P_WeekBeginDate,@OutputMessage OUT

Select @OutputMessage

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLDenis]

you have to call the proc from code and dump the output variable into a another variable

are you sure you don't want this instead?

SET @P_Msg = '0 schedules replicated'
SELECT @P_Msg

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[DavidPike]

George Solved it for me. I was putting the OUTPUT qualifier on the variable in the CREATE statement but not in the EXEC statement. It works now, thanks.