spFundRaiserSolicitorContactsWithNoOpenedEmail
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundraiserSolicitorsID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserSolicitorContactsWithNoOpenedEmail
(@FundraiserSolicitorsID int)
AS
SELECT
DISTINCT Contact.ID as SolicitorContactID
FROM
dbo.FundraiserSolicitorContact Contact
inner join dbo.FundraiserSolicitorContactAction ContactActionSent on ContactActionSent.FundraiserSolicitorContactID = Contact.ID
inner join dbo.FundraiserSolicitorEmail FREmail on FREmail.ID = ContactActionSent.FundRaiserSolicitorEmailID
inner join dbo.EmailJob_Recipient EmailRecip on EmailRecip.EmailJobID = FREmail.EmailJobID
WHERE
Contact.FundraiserSolicitorsID = @FundraiserSolicitorsID
and
ContactActionSent.Type IN (1,2,3,4,12)
and
EmailRecip.Opened = 0
and
EmailRecip.AddressbookID = ContactActionSent.AddressbookContactsID