CREATE TABLE [dbo].[QuoteCommunications] (
	[QuotePersonID] [int] NOT NULL ,
	[CommType] [varchar] (10) NOT NULL ,
	[CommValue] [varchar] (50) NOT NULL 
)

INSERT INTO QuoteCommunications VALUES (1,'Email','test@test.com');
INSERT INTO QuoteCommunications VALUES (1,'Phone','867-5309');
INSERT INTO QuoteCommunications VALUES (2,'Email','');
INSERT INTO QuoteCommunications VALUES (2,'Phone','');


UPDATE QuoteCommunications SET
	CommValue = a.CommValue
FROM
	QuoteCommunications a JOIN QuoteCommunications b ON a.CommType = b.CommType
WHERE
	a.QuotePersonID = 1
	AND b.QuotePersonID = 2


UPDATE QuoteCommunications SET
	CommValue = a.CommValue
FROM
	QuoteCommunications a
WHERE
	a.QuotePersonID = 1
	AND QuotePersonID = 2
	AND a.CommType = CommType