USP_SIMPLEDATALIST_DAILYSALEITEMDONATION_DESIGNATION

            CREATE procedure dbo.USP_SIMPLEDATALIST_DAILYSALEITEMDONATION_DESIGNATION as
                select 
                    ID as VALUE,
                    case VANITYNAME
                        when '' then NAME
                        else VANITYNAME
                    end as LABEL
                from dbo.DESIGNATION
                where ISACTIVE = 1
                order by LABEL