UFN_CLASSMEETING_GETSUMMARY

CREATE function dbo.UFN_CLASSMEETING_GETSUMMARY
(
    @CLASSMEETINGID uniqueidentifier
)
returns @RESULTS TABLE
(
    [TIME] nvarchar(100),
    [CLASSID] nvarchar(1000),
    [FACULTY] nvarchar(1000)
)
begin

    insert into @RESULTS
    select
        case when CLASSMEETINGTEMPLATE.TIMETABLEDAYPERIODID is null
            then dbo.UFN_HOURMINUTE_DISPLAYTIME(CLASSMEETINGTEMPLATE.STARTTIME) + ' - '
                + dbo.UFN_HOURMINUTE_DISPLAYTIME(CLASSMEETINGTEMPLATE.ENDTIME)
            else dbo.UFN_CLASSMEETINGTEMPLATE_GETPERIODSTRING(CLASSMEETINGTEMPLATE.ID, CLASSMEETINGTEMPLATE.LENGTHINPERIODS) + ' ('
                + dbo.UFN_HOURMINUTE_DISPLAYTIME(CLASSMEETINGTEMPLATE.STARTTIME) + ' - '
                + dbo.UFN_HOURMINUTE_DISPLAYTIME(CLASSMEETINGTEMPLATE.ENDTIME) + ')'
        end as [TIME],
        dbo.UFN_CLASS_GETNAME(CLASS.ID) AS CLASSID,
        dbo.UFN_CLASS_GETFACULTYSTRING(CLASS.ID) as FACULTY
    from dbo.CLASSMEETING
        inner join dbo.EDUCATIONMEETING on CLASSMEETING.EDUCATIONMEETINGID = EDUCATIONMEETING.ID
        inner join dbo.CLASSMEETINGGROUP on CLASSMEETING.CLASSMEETINGGROUPID = CLASSMEETINGGROUP.ID
        inner join dbo.CLASS on CLASSMEETINGGROUP.CLASSID = CLASS.ID
        inner join dbo.COURSE on CLASS.COURSEID = COURSE.ID
        inner join dbo.SCHEDULEDATE on COURSE.SCHOOLID = SCHEDULEDATE.SCHOOLID
            and EDUCATIONMEETING.STARTDATE = SCHEDULEDATE.DATE
        inner join dbo.TIMETABLEDAY on SCHEDULEDATE.TIMETABLEDAYID = TIMETABLEDAY.ID
        inner join dbo.CLASSMEETINGTEMPLATE on CLASSMEETING.CLASSMEETINGGROUPID = CLASSMEETINGTEMPLATE.CLASSMEETINGGROUPID
            and TIMETABLEDAY.CYCLEDAYID = CLASSMEETINGTEMPLATE.CYCLEDAYID
            and EDUCATIONMEETING.STARTTIME = CLASSMEETINGTEMPLATE.STARTTIME
            and EDUCATIONMEETING.ENDTIME = CLASSMEETINGTEMPLATE.ENDTIME
    where CLASSMEETING.ID = @CLASSMEETINGID

    return
end