USP_DATALIST_PATTERN

                CREATE procedure dbo.USP_DATALIST_PATTERN
                    (
                        @TIMETABLEID uniqueidentifier = null,
                        @INCLUDEINACTIVE bit = 0
                    )
                as
                    set nocount on;

                    select PATTERN.ID,
                           PATTERN.NAME,
                           PATTERN.DESCRIPTION,
                           (SELECT NAME FROM DBO.TIMETABLE WHERE ID = PATTERN.TIMETABLEID) TIMETABLENAME,
                           PATTERN.ISACTIVE

                    from dbo.PATTERN
                    where ((@TIMETABLEID is null) or (PATTERN.TIMETABLEID = @TIMETABLEID)) and                        
                        (
                            (@INCLUDEINACTIVE = 1) 
                            or 
                            (ISACTIVE = 1)
                        )