fnGetAppealListFinalEmailStatus
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AppealListID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnGetAppealListFinalEmailStatus](@AppealListID int)
RETURNS INT
as
BEGIN
DECLARE @status INT
SELECT @status = ej.Status FROM EmailJob ej
INNER JOIN Email e on ej.EmailID = e.[ID]
INNER JOIN EmailProjectAppeal_ListEmail epale on e.[ProjectAppealListEmailID] = epale.[ID]
WHERE e.[Type] = 8 AND epale.EmailProjectAppealListID = @AppealListID
IF @status is null
SET @status = -1
return @status
END