USP_DATALIST_TIMETABLE

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

                    select TIMETABLE.ID,
                           TIMETABLE.NAME,
                           TIMETABLE.DESCRIPTION,
                           (SELECT NAME FROM DBO.CYCLE WHERE ID = TIMETABLE.CYCLEID) CYCLENAME,
                           (select dbo.UDA_BUILDLIST(ACADEMICYEARNAMECODE.DESCRIPTION + ': ' + CONSTITUENT.NAME + ' ' + SESSIONNAMECODE.DESCRIPTION)
                               from dbo.SESSION
                               inner join ACADEMICYEAR on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID 
                               inner join dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID 
                               inner join CONSTITUENT on ACADEMICYEAR.SCHOOLID = CONSTITUENT.ID
                               inner join SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
                               where SESSION.ACADEMICYEARID = ACADEMICYEAR.ID AND SESSION.TIMETABLEID = TIMETABLE.ID
                               and ((GETDATE() >= ACADEMICYEAR.STARTDATE AND GETDATE() < ACADEMICYEAR.ENDDATE) or GETDATE() < ACADEMICYEAR.STARTDATE)) AS USED_BY,
                           TIMETABLE.ISACTIVE
                    from dbo.TIMETABLE
                    where ((@CYCLEID is null) or (TIMETABLE.CYCLEID = @CYCLEID)) and                        
                        (
                            (@INCLUDEINACTIVE = 1) 
                            or 
                            (ISACTIVE = 1)
                        )