UFN_CLASSMEETINGGROUP_GETFIRSTMEETING

create function dbo.UFN_CLASSMEETINGGROUP_GETFIRSTMEETING
(
    @CLASSMEETINGGROUPID uniqueidentifier
)
returns nvarchar(100)
as begin    
    return
        (
            select top(1)
                CYCLEDAY.CODE + ' ' +
                    case when TIMETABLEDAYPERIOD.ID is null
                        then dbo.UFN_HOURMINUTE_DISPLAYTIME(CLASSMEETINGTEMPLATE.STARTTIME) + ' - '
                            + dbo.UFN_HOURMINUTE_DISPLAYTIME(CLASSMEETINGTEMPLATE.ENDTIME)
                        else dbo.UFN_CLASSMEETINGTEMPLATE_GETPERIODSTRING(CLASSMEETINGTEMPLATE.ID, CLASSMEETINGTEMPLATE.LENGTHINPERIODS)
                    end
            from dbo.CLASSMEETINGTEMPLATE
                inner join dbo.CYCLEDAY on CLASSMEETINGTEMPLATE.CYCLEDAYID = CYCLEDAY.ID
                left join dbo.TIMETABLEDAYPERIOD on CLASSMEETINGTEMPLATE.TIMETABLEDAYPERIODID = TIMETABLEDAYPERIOD.ID
            where CLASSMEETINGGROUPID = @CLASSMEETINGGROUPID
            order by CYCLEDAY.SEQUENCE, CLASSMEETINGTEMPLATE.STARTTIME
        )
end