UFN_FUNDRAISINGGROUP_PARTICIPANTNUMBER

Calculate group number of participant recruited.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_FUNDRAISINGGROUP_PARTICIPANTNUMBER
(
    @ID uniqueidentifier
)
returns int
with execute as caller
as begin

    return (
        select COUNT(fc.TYPEGUID)     
        from      dbo.FAFCOMMUNICATIONSLOG fl
        join      dbo.FAFEVENTCOMMUNICATIONCHANNEL fc on fl.EMAILJOBID = fc.EMAILJOBID
        where      fc.TYPEGUID IN (
                select REGISTRANTID from dbo.UFN_REGISTRANT_GROUPMEMBERLIST() RG
                inner join dbo.TEAMEXTENSION TE ON TE.TEAMFUNDRAISINGTEAMID=RG.GROUPID 
                where GROUPID=@ID  AND RG.TYPECODE=TE.TYPECODE)
    )
end