USP_SIMPLEDATALIST_MAILPREFERENCEEMAILADDRESS

                create procedure USP_SIMPLEDATALIST_MAILPREFERENCEEMAILADDRESS(
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        e.ID VALUE,
                        coalesce('(' + etc.DESCRIPTION + ') ' ,'') + e.EMAILADDRESS LABEL
                    from EMAILADDRESS e
                        left join EMAILADDRESSTYPECODE etc on etc.ID=e.EMAILADDRESSTYPECODEID
                    where e.CONSTITUENTID=@CONSTITUENTID and 
                        e.DONOTEMAIL = 0