USP_SIMPLEDATALIST_PATTERN_BYSESSION

                CREATE procedure dbo.USP_SIMPLEDATALIST_PATTERN_BYSESSION
                (
                    @SESSIONID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                ) 
                as

                select 
                    PATTERN.ID as VALUE, 
                    PATTERN.NAME as LABEL
                from 
                    [SESSION]
                    join 
                        dbo.TIMETABLE on TIMETABLE.ID = [SESSION].TIMETABLEID
                    join 
                        dbo.PATTERN on PATTERN.TIMETABLEID = TIMETABLE.ID
                where 
                    [SESSION].ID = @SESSIONID and
                    (
                        (@INCLUDEINACTIVE = 1) 
                        or 
                        (PATTERN.ISACTIVE = 1)
                    )
                order by
                    PATTERN.NAME