spFundRaiserTeamActionTotalsByType
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundRaiserTeamID | int | IN | |
| @Type | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserTeamActionTotalsByType
(
@FundRaiserTeamID int,
@Type int
)
AS
If @type = 0
SELECT
Count(FRAction.ID) as ActionTotal,
FRAction.Type
FROM
dbo.FundraiserSolicitorContactAction FRAction
inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ID = FRAction.FundraiserSolicitorsID
inner join dbo.FundRaiserTeams Team on Team.ID = Solicitor.TeamID
WHERE
Team.ID = @FundRaiserTeamID
GROUP BY FRAction.Type
else
SELECT
Count(FRAction.ID) as ActionTotal,
FRAction.Type
FROM
dbo.FundraiserSolicitorContactAction FRAction
inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ID = FRAction.FundraiserSolicitorsID
inner join dbo.FundRaiserTeams Team on Team.ID = Solicitor.TeamID
WHERE
Team.ID = @FundRaiserTeamID
and
FRAction.Type = @type
GROUP BY FRAction.Type