UFN_SESSION_GETDAYS

Returns a comma delimited list of week days valid in a session.
Return

Return Type
varchar(1000)
Parameters

Parameter	Parameter Type	Mode	Description
@SESSIONID	uniqueidentifier	IN
Definition

Copy


            CREATE FUNCTION dbo.UFN_SESSION_GETDAYS
            (
                @SESSIONID uniqueidentifier
            )
            RETURNS VARCHAR(1000)
            AS
            BEGIN
                DECLARE @DayList varchar(1000)
                set @DayList = ''

                if (select SUNDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = 'Sunday'
                if (select MONDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = case when @DayList = '' then 'Monday' else @DayList + '; ' + 'Monday' end
                if (select TUESDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = case when @DayList = '' then 'Tuesday' else @DayList + '; ' + 'Tuesday' end
                if (select WEDNESDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = case when @DayList = '' then 'Wednesday' else @DayList + '; ' + 'Wednesday' end
                if (select THURSDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = case when @DayList = '' then 'Thursday' else @DayList + '; ' + 'Thursday' end
                if (select FRIDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = case when @DayList = '' then 'Friday' else @DayList + '; ' + 'Friday' end
                if (select SATURDAY from SESSION where ID = @SESSIONID) = 1
                    set @DayList = case when @DayList = '' then 'Saturday' else @DayList + '; ' + 'Saturday' end
                RETURN @DayList
            END