USP_SIMPLEDATALIST_MERCHANDISEDEPARTMENTCATEGORY

            CREATE procedure dbo.USP_SIMPLEDATALIST_MERCHANDISEDEPARTMENTCATEGORY
            (
                @MERCHANDISEDEPARTMENTID uniqueidentifier = null,
                @FILTERBYDEPARTMENT bit = 1,
                @INCLUDEINACTIVE bit = 1
            )
            as
            select 
                ID as VALUE, 
                NAME as LABEL
            from dbo.MERCHANDISEDEPARTMENTCATEGORY
            where (@FILTERBYDEPARTMENT = 0 or (MERCHANDISEDEPARTMENTID = @MERCHANDISEDEPARTMENTID))
            and (@INCLUDEINACTIVE = 1 or ISACTIVE = 1)
            order by NAME