USP_DATALIST_CONSTITUENTFORMATADDRESS

Builds a constituent

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESSBLOCK	nvarchar(150)	IN	Address block
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State ID
@POSTCODE	nvarchar(12)	IN	ZIP
@COUNTRYID	uniqueidentifier	IN	Country ID

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTFORMATADDRESS
                    (
                        @ADDRESSBLOCK nvarchar(150),
                        @CITY nvarchar(50),
                        @STATEID uniqueidentifier,
                        @POSTCODE nvarchar(12),
                        @COUNTRYID uniqueidentifier                        
                    )
                    as
                        set nocount on

                        select dbo.UFN_BUILDFULLADDRESS(null, @ADDRESSBLOCK, @CITY, @STATEID, @POSTCODE, @COUNTRYID) as FORMATTEDADDRESS