spFundRaiserSolicitorActionTotalsByType
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundRaiserSolicitorsID | int | IN | |
| @Type | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserSolicitorActionTotalsByType
(
@FundRaiserSolicitorsID int,
@Type int
)
AS
If @type = 0
SELECT
Count(FRAction.ID) as ActionTotal,
FRAction.Type
FROM
dbo.FundraiserSolicitorContactAction FRAction
WHERE
FRAction.FundraiserSolicitorsID = @FundRaiserSolicitorsID
GROUP BY FRAction.Type
else
SELECT
Count(FRAction.ID) as ActionTotal,
FRAction.Type
FROM
dbo.FundraiserSolicitorContactAction FRAction
WHERE
FRAction.FundraiserSolicitorsID = @FundRaiserSolicitorsID
and
FRAction.Type = @type
GROUP BY FRAction.Type