spFundRaiserSolicitorContactsbyAppealedNotDonated
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundraiserSolicitorsID | int | IN | |
| @Appealed | bit | IN | |
| @HaveDonated | bit | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserSolicitorContactsbyAppealedNotDonated
(
@FundraiserSolicitorsID int,
@Appealed bit,
@HaveDonated bit
)
AS
SELECT
DISTINCT FRContact.ID as SolicitorContactID
FROM
dbo.FundraiserSolicitorContact FRContact
inner join dbo.FundraiserSolicitorContactAction ContactAction on ContactAction.FundraiserSolicitorContactID = FRContact.ID
WHERE
FRContact.FundraiserSolicitorsID = @FundraiserSolicitorsID
and
FRContact.Appeal = @Appealed
and
dbo.fnFundRaiserSolicitorContactHasDonations(FRContact.ID) = @HaveDonated