UFN_STUDENTENROLLMENT_RECORDCOUNT

The enrollment record count for a student.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_STUDENTENROLLMENT_RECORDCOUNT(
            @STUDENTID uniqueidentifier
        )
        returns integer
        with execute as caller
        as begin
            declare @RECORDCOUNT as integer

            set @RECORDCOUNT = (SELECT COUNT(EDUCATIONALHISTORY.[ID]) 
            from  dbo.EDUCATIONALHISTORY 
            inner join dbo.SCHOOL on dbo.EDUCATIONALHISTORY.[EDUCATIONALINSTITUTIONID] = dbo.SCHOOL.[ID] 
            where dbo.EDUCATIONALHISTORY.[CONSTITUENTID] = @STUDENTID)

            return @RECORDCOUNT
        end