Skip to main content

Return to Answer

Code formatting.
Source Link
Giacomo1968
Giacomo1968
  • 25.3k
  • 11
  • 78
  • 106

Try this if you have more than two Columns 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

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

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
Formatted text and code
Source Link
Chiragkumar Thakar
Chiragkumar Thakar
  • 3.7k
  • 5
  • 39
  • 50

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

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

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

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
Source Link
Khati Lx
Khati Lx
  • 39
  • 6

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