UFN_SCHEDULEDATE_INSESSION_VALID

Check to see if the day is valid for the given date

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@DATE	date	IN
@SCHOOLID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SCHEDULEDATE_INSESSION_VALID
            (
              @DATE date,
              @SCHOOLID uniqueidentifier
            )
            returns BIT
            as begin
                declare @SESSIONID uniqueidentifier
                set @SESSIONID = dbo.UFN_SCHEDULEDATE_GETSESSION (@DATE, @SCHOOLID)

                return
                (select case 
                when (DATENAME(WEEKDAY,@DATE) = 'Sunday' and (select SUNDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                when (DATENAME(WEEKDAY,@DATE) = 'Monday' and (select MONDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                when (DATENAME(WEEKDAY,@DATE) = 'Tuesday' and (select TUESDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                when (DATENAME(WEEKDAY,@DATE) = 'Wednesday' and (select WEDNESDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                when (DATENAME(WEEKDAY,@DATE) = 'Thursday' and (select THURSDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                when (DATENAME(WEEKDAY,@DATE) = 'Friday' and (select FRIDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                when (DATENAME(WEEKDAY,@DATE) = 'Saturday' and (select SATURDAY from SESSION where ID = @SESSIONID) = 1) then 1 
                else 0 end)
            end