USP_WEBFORMS_CONSTITUENT_ADDRESSINFORMATION

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@PHONEID	uniqueidentifier	INOUT
@PHONE	nvarchar(100)	INOUT
@EMAILID	uniqueidentifier	INOUT
@EMAIL	nvarchar(100)	INOUT
@ADDRESSID	uniqueidentifier	INOUT
@COUNTRYID	uniqueidentifier	INOUT
@STATEID	uniqueidentifier	INOUT
@ADDRESSBLOCK	nvarchar(150)	INOUT
@CITY	nvarchar(50)	INOUT
@POSTCODE	nvarchar(12)	INOUT

Definition

Copy



            create procedure dbo.USP_WEBFORMS_CONSTITUENT_ADDRESSINFORMATION (
                @CONSTITUENTID uniqueidentifier,
                @PHONEID uniqueidentifier = null output,
                @PHONE nvarchar(100) = null output,
                @EMAILID uniqueidentifier = null output,
                @EMAIL nvarchar(100) = null output,
                @ADDRESSID uniqueidentifier = null output,
                @COUNTRYID uniqueidentifier = null output,
                @STATEID uniqueidentifier = null output,
                @ADDRESSBLOCK nvarchar(150) = null output,
                @CITY nvarchar(50) = null output,
                @POSTCODE nvarchar(12) = null output
            )
            as
            begin
                select 
                    @PHONEID = [PHONE].[ID],
                    @PHONE = [PHONE].[NUMBER]
                from dbo.[PHONE]
                where 
                    [PHONE].[CONSTITUENTID] = @CONSTITUENTID and
                    [PHONE].[ISPRIMARY] = 1

                select 
                    @EMAILID = [EMAILADDRESS].[ID],
                    @EMAIL = [EMAILADDRESS].[EMAILADDRESS]
                from dbo.[EMAILADDRESS]
                where 
                    [EMAILADDRESS].[CONSTITUENTID] = @CONSTITUENTID and
                    [EMAILADDRESS].[ISPRIMARY] = 1

                select
                    @ADDRESSID = [ADDRESS].[ID],
                    @COUNTRYID = [ADDRESS].[COUNTRYID],
                    @STATEID = [ADDRESS].[STATEID],
                    @ADDRESSBLOCK = [ADDRESS].[ADDRESSBLOCK],
                    @CITY = [ADDRESS].[CITY],
                    @POSTCODE = [ADDRESS].[POSTCODE]
                from dbo.[ADDRESS]
                where
                    [ADDRESS].[CONSTITUENTID] = @CONSTITUENTID and
                    [ADDRESS].[ISPRIMARY] = 1
            end