UFN_EDUCATIONALHISTORY_PRIMARYCOUNT

Returns the number of primary alumni records for a constituent.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EDUCATIONALHISTORY_PRIMARYCOUNT(@CONSTITUENTID uniqueidentifier)
            returns int
            as begin
                return (select count(*) from dbo.EDUCATIONALHISTORY where (CONSTITUENTID = @CONSTITUENTID) and (ISPRIMARYRECORD = 1))
            end