USP_IDMAPPER_CONSTITUENT_TO_PRIMARYADDRESS

Parameters

Parameter	Parameter Type	Mode	Description
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	INOUT

Definition

Copy



            create procedure  dbo.USP_IDMAPPER_CONSTITUENT_TO_PRIMARYADDRESS(
                @SOURCEID uniqueidentifier,
                @TARGETID uniqueidentifier output
            )
            as
                set nocount on;

                select @TARGETID=ID 
                from dbo.ADDRESS 
                where 
                    CONSTITUENTID=@SOURCEID and
                    ISPRIMARY=1;