UFN_BATCHSPONSORSHIPGROUPMEMBER_PRIMARYCOUNT

This function retrieves the count of primary contacts for a group

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCHSPONSORSHIPGROUPMEMBER_PRIMARYCOUNT(@GROUPID uniqueidentifier)
            returns int
            as
            begin
                return (select count(*) from dbo.BATCHSPONSORSHIPCONSTITUENTGROUPMEMBER where (GROUPID = @GROUPID) and (ISPRIMARY = 1))
            end