USP_SALESORDER_RECIPIENTADDRESS_SIMPLEDATALIST

Provides a list of addresses that have addresses

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID

Definition

Copy



                CREATE procedure dbo.USP_SALESORDER_RECIPIENTADDRESS_SIMPLEDATALIST(
                    @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),' ') LABEL
                    from ADDRESS 
                        left join ADDRESSTYPECODE on ADDRESSTYPECODE.ID = ADDRESS.ADDRESSTYPECODEID
                    where ADDRESS.CONSTITUENTID = @CONSTITUENTID and 
                        ADDRESS.ADDRESSBLOCK <> ''
                    order by ADDRESS.ISPRIMARY DESC