USP_SIMPLEDATALIST_EVENTDESIGNATION

            CREATE procedure dbo.USP_SIMPLEDATALIST_EVENTDESIGNATION
            (
                @EVENTID uniqueidentifier
            )
            as
                select 
                    designation.ID as VALUE,
                    case VANITYNAME
                        when '' then NAME
                        else VANITYNAME
                    end as LABEL
                from dbo.EVENTDESIGNATION
                inner join dbo.DESIGNATION on EVENTDESIGNATION.DESIGNATIONID=DESIGNATION.ID
                where EVENTID = @EVENTID and ISACTIVE = 1
                order by LABEL