USP_SIMPLEDATALIST_MERCHANDISEDEPARTMENT

            CREATE procedure dbo.USP_SIMPLEDATALIST_MERCHANDISEDEPARTMENT
            (
                @INCLUDEINACTIVE bit = 1,
                @DISCOUNTABLEONLY bit = 0
            )
            as
            select 
                ID as VALUE, 
                NAME as LABEL
            from dbo.MERCHANDISEDEPARTMENT
            where (@INCLUDEINACTIVE = 1 or ISACTIVE = 1)
                and ((@DISCOUNTABLEONLY = 1 and ISDISCOUNTABLE = 1) or @DISCOUNTABLEONLY = 0)
            order by NAME