spFundRaiserSolicitorEmailIDByOpened
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundRaiserSolicitorsID | int | IN | |
| @Opened | bit | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserSolicitorEmailIDByOpened
(
@FundRaiserSolicitorsID int,
@Opened bit
)
AS
SELECT
DISTINCT frse.id as SolicitorEmailID
FROM
dbo.FundraiserSolicitorEmail frse
inner join dbo.EmailJob_Recipient ejr on ejr.EmailJobID = frse.EmailJobID
WHERE
frse.FundRaiserSolicitorsID = @FundRaiserSolicitorsID
and
ejr.opened = @Opened
group by frse.CreateDate,frse.id