Unnamed

CREATE TABLE #Example(	Id INT,	IsReference BIT,	S1 VARCHAR(255),	S2 VARCHAR(255),	Col1 BIT,	Col2 BIT,	Col3 BIT,	Col4 BIT);INSERT INTO #Example (Id, IsReference, S1, S2, Col1, Col2, Col3, Col4) VALUES(1, 1, 'Field 1', 'Field 2', 1, 1, 1, 0);INSERT INTO #Example (Id, IsReference, S1, S2, Col1, Col2, Col3, Col4) VALUES(1, 1, 'Field 3', 'Field 4', 1, 0, 0, 1);INSERT INTO #Example (Id, IsReference, S1, S2, Col1, Col2, Col3, Col4) VALUES(2, 0, 'Field 1', 'Field 2', 1, 1, 0, 0);INSERT INTO #Example (Id, IsReference, S1, S2, Col1, Col2, Col3, Col4) VALUES(2, 0, 'Field 3', 'Field 4', 1, 0, 0, 1);SELECT	T1.S1 AS S1, T1.S2 AS S2,	T1.Col1 AS BaseCol1, T1.Col2 AS BaseCol2, T1.Col3 AS BaseCol3, T1.Col4 AS BaseCol4,	T2.Col2 AS CompCol1, T2.Col2 AS CompCol2, T2.Col3 AS CompCol3, T2.Col4 AS CompCol4FROM	#Example T1, #Example T2WHERE(	T1.Col1 <> T2.Col1 OR	T1.Col2 <> T2.Col2 OR	T1.Col3 <> T2.Col3 OR	T1.Col4 <> T2.Col4) AND	T1.S1 = T2.S1 AND	T1.S2 = T2.S2 AND	T1.IsReference = 1	DROP TABLE #Example