USP_SIMPLEDATALIST_MAILPREFERENCEADDRESSFOREDIT

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

                    select 
                        ADDRESS.ID VALUE,
                        case ADDRESS.DONOTMAIL when 1 then 'Invalid - ' 
                                else '' end +
                            coalesce('('+ADDRESSTYPECODE.DESCRIPTION+') ','') +  
                            dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK,ADDRESS.CITY,ADDRESS.STATEID,ADDRESS.POSTCODE,ADDRESS.COUNTRYID) LABEL
                    from MAILPREFERENCE
                        join ADDRESS ADDRESS on ADDRESS.CONSTITUENTID = MAILPREFERENCE.CONSTITUENTID
                        left join ADDRESSTYPECODE on ADDRESSTYPECODE.ID = ADDRESS.ADDRESSTYPECODEID
                    where MAILPREFERENCE.ID=@MAILPREFERENCEID and 
                        ((ADDRESS.DONOTMAIL = 0) or (ADDRESS.DONOTMAIL=1 and MAILPREFERENCE.ADDRESSID=ADDRESS.ID))
                    order by ADDRESS.SEQUENCE