USP_SIMPLEDATALIST_CYCLE

                CREATE procedure dbo.USP_SIMPLEDATALIST_CYCLE 
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as 
                select 
                    ID as VALUE, 
                    NAME as LABEL
                from dbo.CYCLE
                where
                    (
                        (@INCLUDEINACTIVE = 1) 
                        or 
                        (ISACTIVE = 1)
                    )
                order by NAME