UFN_CLASSMEETINGGROUP_GETSTUDENTCOUNT

CREATE function dbo.UFN_CLASSMEETINGGROUP_GETSTUDENTCOUNT
(
    @CLASSMEETINGGROUPID uniqueidentifier
)
returns int
with execute as caller
as begin
    declare @COUNT int

    select @COUNT = COUNT(STUDENTCLASSMEETINGGROUP.ID)
    from dbo.STUDENTCLASSMEETINGGROUP
        inner join dbo.CLASSMEETINGGROUP on STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = CLASSMEETINGGROUP.ID
    where CLASSMEETINGGROUP.ID = @CLASSMEETINGGROUPID
        and STUDENTCLASSMEETINGGROUP.STATUSCODE = 0

    return @COUNT
end