UFN_ADDRESS_PRIMARYCOUNT

Returns the number of primary addresses for a constituent.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



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