fnFundraiserIsCaptain

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@TeamID	int	IN
@SolicitorID	int	IN
@FundraiserID	int	IN

Definition

Copy



        CREATE FUNCTION [dbo].[fnFundraiserIsCaptain](    
            @TeamID int,
            @SolicitorID int,
            @FundraiserID int)
        RETURNS int
        AS
        BEGIN
            DECLARE @Count int
            DECLARE @IsCaptain bit

            SET @IsCaptain = 0

            SELECT @Count = Count(*) FROM [dbo].[FundRaiserTeams] 
            WHERE [CaptainID]=@SolicitorID
            AND [ID]=@TeamID
            AND [RootFundraiserID] = @FundraiserID

            IF @Count > 0
                SET @IsCaptain = 1

            RETURN @IsCaptain
        END