USP_SIMPLEDATALIST_MAILPREFERENCEEMAILADDRESSFOREDIT

                CREATE procedure USP_SIMPLEDATALIST_MAILPREFERENCEEMAILADDRESSFOREDIT(
                    @MAILPREFERENCEID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        e.ID VALUE,
                        case e.DONOTEMAIL when 1 then 'Invalid - ' else '' end +
                            coalesce('(' + etc.DESCRIPTION + ') ' ,'') + e.EMAILADDRESS LABEL
                    from MAILPREFERENCE mp
                        join EMAILADDRESS e on e.CONSTITUENTID=mp.CONSTITUENTID
                        left join EMAILADDRESSTYPECODE etc on etc.ID=e.EMAILADDRESSTYPECODEID
                    where mp.ID=@MAILPREFERENCEID and 
                        ((e.DONOTEMAIL = 0) or (e.DONOTEMAIL=1 and e.ID=mp.EMAILADDRESSID))