UFN_COURSERESTRICTION_SESSIONPATTERN_VALID

create function dbo.UFN_COURSERESTRICTION_SESSIONPATTERN_VALID(
    @COURSEID uniqueidentifier,
    @STARTDATE date,
    @ENDDATE date,
    @PATTERNID uniqueidentifier
)
returns bit
with execute as caller
as begin

    declare @retval bit = 0

    declare @SCHOOLID uniqueidentifier
    select @SCHOOLID = SCHOOLID from dbo.COURSE where COURSE.ID = @COURSEID

    if exists(select 
                PATTERN.ID
            from 
                [SESSION]
                join 
                    dbo.TIMETABLE on TIMETABLE.ID = [SESSION].TIMETABLEID
                join 
                    dbo.PATTERN on PATTERN.TIMETABLEID = TIMETABLE.ID
            where 
                [SESSION].ID = dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(@SCHOOLID, @STARTDATE, @ENDDATE)
                and PATTERN.ID = @PATTERNID)
        set @retval = 1


    return @retval

end