USP_SIMPLEDATALIST_CONSTITUENT_ADDRESSPOSTCODE

Returns postcode information for a given constituent's primary address for use in marketing data collection.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_CONSTITUENT_ADDRESSPOSTCODE
            (@CONSTITUENTID uniqueidentifier = null)
            as
                select 
                    -- a "has address" flag

                    case ID
                        when null then 0
                        else 1
                    end as VALUE, 
                    POSTCODE as LABEL
                from dbo.ADDRESS
                where CONSTITUENTID = @CONSTITUENTID
                and ISPRIMARY = 1