USP_SIMPLEDATALIST_MAILPREFERENCEADDRESS

Retrieves a list of addresses, formatted for use in mail preference forms.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID

Definition

Copy



                CREATE procedure USP_SIMPLEDATALIST_MAILPREFERENCEADDRESS(
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        ADDRESS.ID VALUE,
                        coalesce('(' + ADDRESSTYPECODE.DESCRIPTION + ') ', '') + 
                            replace(
                                dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID),
                                nchar(13) + nchar(10),
                                nchar(44) + nchar(32)
                            ) LABEL
                    from ADDRESS 
                        left join ADDRESSTYPECODE on ADDRESSTYPECODE.ID = ADDRESS.ADDRESSTYPECODEID
                    where ADDRESS.CONSTITUENTID = @CONSTITUENTID and 
                        ADDRESS.DONOTMAIL = 0
                    order by ADDRESS.SEQUENCE