spFundRaiserSolicitorContactsByActionType
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundRaiserSolicitorsID | int | IN | |
| @ContactActionType | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserSolicitorContactsByActionType
(
@FundRaiserSolicitorsID int,
@ContactActionType int
)
AS
IF @ContactActionType > 0
BEGIN
SELECT
c.id as AddressBookContactID,
frsc.id as SolicitorContactID
FROM
dbo.FundRaiserSolicitors frs
inner join dbo.FundraiserSolicitorContact frsc on frsc.FundraiserSolicitorsID = frs.id
inner join dbo.AddressBookContacts c on c.id = frsc.AddressbookContactsID
inner join dbo.FundraiserSolicitorContactAction frsca on frsca.FundraiserSolicitorContactID = frsc.id
Where
frs.ID = @FundRaiserSolicitorsID
and
frsca.type = @ContactActionType
GROUP BY
c.lastname,frsc.id,c.id
END
ELSE
BEGIN
SELECT
c.id as AddressBookContactID,
frsc.id as SolicitorContactID
FROM
dbo.FundRaiserSolicitors frs
inner join dbo.FundraiserSolicitorContact frsc on frsc.FundraiserSolicitorsID = frs.id
inner join dbo.AddressBookContacts c on c.id = frsc.AddressbookContactsID
inner join dbo.FundraiserSolicitorContactAction frsca on frsca.FundraiserSolicitorContactID = frsc.id
Where
frs.ID = @FundRaiserSolicitorsID
GROUP BY
c.lastname,frsc.id,c.id
END