I have a stored procedure that I can't tell if it is working.
<code>
alter procedure dbo.confirmcomplete
(
@requestID varchar(50)
)
as
set nocount on;
if not exists (select mId from table where mID = @requestID)
return(0)
else
if not exists (select mID from table where mId = @requestID and mCriteria2 = @criteria2)
return(2)
</code>
this stored procedure seems to no be sending the return values 0 or 2.
Please help. I have code that depends on the return values of these sp's.
Thanks.
<code>
alter procedure dbo.confirmcomplete
(
@requestID varchar(50)
)
as
set nocount on;
if not exists (select mId from table where mID = @requestID)
return(0)
else
if not exists (select mID from table where mId = @requestID and mCriteria2 = @criteria2)
return(2)
</code>
this stored procedure seems to no be sending the return values 0 or 2.
Please help. I have code that depends on the return values of these sp's.
Thanks.