UFN_TIMETABLEDAYS_INUSE

            create function dbo.UFN_TIMETABLEDAYS_INUSE
            (
                @TIMETABLEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @RETVAL bit = 0;

                    if exists 
                        (select * from dbo.PATTERNBLOCKMEETING
                        inner join dbo.TIMETABLEDAY on TIMETABLEDAY.ID = PATTERNBLOCKMEETING.TIMETABLEDAYID
                        where TIMETABLEDAY.TIMETABLEID = @TIMETABLEID)
                        set @RETVAL = 1;

                return @RETVAL;
            end