UFN_CLASS_GETSTUDENTCOUNTBYGENDER

Returns the number of students enrolled in a class with the given gender.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CLASSID	uniqueidentifier	IN
@GENDERCODE	int	IN

Definition

Copy



CREATE function dbo.UFN_CLASS_GETSTUDENTCOUNTBYGENDER
(
    @CLASSID uniqueidentifier,
    @GENDERCODE int
)
returns int
with execute as caller
as begin
    declare @COUNT int

    select @COUNT = COUNT(CONSTITUENT.ID)
    from (
            select
                STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID,
                CLASSMEETINGGROUP.CLASSID
            from dbo.STUDENTCLASSMEETINGGROUP
                inner join dbo.CLASSMEETINGGROUP on dbo.STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = dbo.CLASSMEETINGGROUP.ID
            where CLASSMEETINGGROUP.CLASSID = @CLASSID
                and STUDENTCLASSMEETINGGROUP.STATUSCODE = 0
            group by STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID, CLASSMEETINGGROUP.CLASSID
        ) STUDENTCLASS
        inner join dbo.STUDENTCOURSE on STUDENTCLASS.STUDENTCOURSEID = STUDENTCOURSE.ID
        inner join dbo.CONSTITUENT on dbo.STUDENTCOURSE.STUDENTID = dbo.CONSTITUENT.ID
    where (@GENDERCODE is null or CONSTITUENT.GENDERCODE = @GENDERCODE)

    return @COUNT
end