DECLARE @Test	TABLE(
	Name	varchar(50),
	Region 	varchar(50),
	City 	varchar(50),
	Status	varchar(50), 
	N_Region 	varchar(50),
	N_City 	varchar(50),
	N_Status 	varchar(50),
	E_Region 	varchar(50),
	E_City 	varchar(50),
	E_Stauts	varchar(50));
	
INSERT @Test VALUES('Peter', 'AMERICA', 'NY', 'A ', 'EMEA ', 'LDN ', 'U ', 'AMERICAS ', 'NY ', 'A'),
('SHAWN', 'AMERICA', 'NY', 'A ', 'EMEA ', 'LDN ', 'U ', 'AMERICAS ', 'LA ', 'A'),
('SHAWN', 'AMERICA', 'NY ', 'A ', 'EMEA ', 'LDN ', 'U ', 'AMERICAS ', 'NY ', 'A'),
('TONY', 'AMERICA', 'NY ', 'A ', 'EMEA ', 'LDN ', 'U ', 'AMERICAS ', 'LA ', 'A'),
('TONY', 'AMERICA', 'NY ', 'A ', 'EMEA ', 'LDN ', 'U ', 'EMEA ', 'LDN ', 'U');

WITH UniqueNames AS(
	SELECT Name
	FROM @Test
	GROUP BY Name
	HAVING COUNT(*) = 1)
SELECT t.*
FROM @Test t
JOIN UniqueNames u ON t.Name = u.Name;