UFN_STUDENTPROGRESSION_RECORDCOUNT

Returns the number of progression records associated with a student.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_STUDENTPROGRESSION_RECORDCOUNT(
            @STUDENTID uniqueidentifier
        )
        returns integer
        with execute as caller
        as begin

            declare @RECORDCOUNT as integer

            set @RECORDCOUNT = (SELECT COUNT(STUDENTPROGRESSION.[ID]) 
            FROM  dbo.EDUCATIONALHISTORY 
            inner join dbo.SCHOOL on dbo.EDUCATIONALHISTORY.[EDUCATIONALINSTITUTIONID] = dbo.SCHOOL.[ID] 
            inner join dbo.STUDENTPROGRESSION on dbo.EDUCATIONALHISTORY.[ID] = dbo.STUDENTPROGRESSION.[ENROLLMENTID] 
            WHERE dbo.EDUCATIONALHISTORY.[CONSTITUENTID] = @STUDENTID)

            return @RECORDCOUNT
        end