USP_DATALIST_CYCLE

                CREATE procedure dbo.USP_DATALIST_CYCLE
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on

                    select CYCLE.ID,
                                 CYCLE.NAME,
                                 (SELECT DBO.UFN_CYCLEDAY_GETDAYS(CYCLE.ID)) DAYS,
                                 ISACTIVE
                    from dbo.CYCLE
                    where
                        (
                            (@INCLUDEINACTIVE = 1) 
                            or 
                            (ISACTIVE = 1)
                        )