Try this if you have more than two Columns
CREATE TABLE #temptable (Name1 VARCHAR(25),Name2 VARCHAR(25)) INSERT INTO #temptable(Name1, Name2) VALUES('JON', 'Harry'), ('JON', 'JON'), ('Sam','harry') SELECT t.Name1+','+t.Name2 Names INTO #t FROM #temptable AS tSELECT DISTINCT ss.value FROM #t AS t CROSS APPLY STRING_SPLIT(T.Names,',') AS ss 