spFundRaiserSolicitorEmailJobIDsByJobStatus
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundRaiserSolicitorID | int | IN | |
| @EmailJobStatus | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserSolicitorEmailJobIDsByJobStatus
(
@FundRaiserSolicitorID int,
@EmailJobStatus int
)
AS
IF (@EmailJobStatus >= 0)
BEGIN
SELECT
fse.id as SolicitorEmailID
FROM
dbo.FundraiserSolicitorEmail fse
inner join dbo.FundRaiserSolicitors frs on frs.id = fse.FundRaiserSolicitorsID
inner join dbo.EmailJob ej on ej.id = fse.EmailJobID
WHERE
frs.id = @FundRaiserSolicitorID
and
ej.status = @EmailJobStatus
ORDER BY
ej.CreateDate DESC
END ELSE BEGIN
SELECT
fse.id as SolicitorEmailID
FROM
dbo.FundraiserSolicitorEmail fse
inner join dbo.FundRaiserSolicitors frs on frs.id = fse.FundRaiserSolicitorsID
inner join dbo.EmailJob ej on ej.id = fse.EmailJobID
WHERE
frs.id = @FundRaiserSolicitorID
ORDER BY
ej.CreateDate DESC
END