USP_IDMAPPER_CONSTITUENT_TO_PRIMARYPHONE

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

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

                    return 0;