UFN_EMAILADDRESS_PRIMARYCOUNT

Returns the number of primary email addresses for a constituent.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EMAILADDRESS_PRIMARYCOUNT(@CONSTITUENTID uniqueidentifier)
            returns int
            as begin
                return (select count(*) from dbo.EMAILADDRESS where (CONSTITUENTID = @CONSTITUENTID) and (ISPRIMARY = 1))
            end