The @return_value is actually the stored procedures return value

CREATE PROCEDURE usp_emailTicket_get_ABANDONED

(

@emailID UNIQUEIDENTIFIER,

@pdfPass VARCHAR(50)

)

AS

SET NOCOUNT ON

DECLARE @BadTries TINYINT,

@pass TINYINT,

@TicketData [red]{your datatype here}[/red]

SELECT@BadTries = badAttempts,

@pass = CASE WHEN pdfPassword = @pdfPass THEN 1 ELSE 0 END,

@TicketData = ticketData

FROMticketEmail

WHEREemailID = @emailID

IF @BadTries IS NULL

RETURN -1

IF @BadTries > 5

RETURN-2

IF @pass < 1

BEGIN

UPDATEticketEmail

SETBadAttempts = BadAttempts + 1

WHEREemailID = @emailID

RETURN -3

END

SELECT@TicketData,

@emailID

RETURN 1