MSSQL 문자열 합치기 STUFF

 

 

 

	DECLARE @TEMP TABLE
	(
		idx INT,
		value varchar(10)
	)
	
	
	INSERT INTO @TEMP(idx, value) values (1, 'Ga')
	INSERT INTO @TEMP(idx, value) values (2, 'Na')
	INSERT INTO @TEMP(idx, value) values (2, 'Da')
	INSERT INTO @TEMP(idx, value) values (3, 'Ra')
	INSERT INTO @TEMP(idx, value) values (3, 'Ma')
	INSERT INTO @TEMP(idx, value) values (3, 'Ba')
	
	SELECT *
	  FROM @TEMP
	 WHERE 1=1	
		
	SELECT DISTINCT 
		   STUFF((
					SELECT ',' + value
					FROM   @TEMP         
					FOR XML PATH('')
		   ),1,1,'') AS value
	  FROM @TEMP AS tp
		
	
	SELECT DISTINCT idx,
		   STUFF((
				SELECT ',' + value
				FROM  @TEMP
				WHERE  idx = tp.idx
				FOR XML PATH('')
		   ),1,1,'') AS value
	  FROM @TEMP AS tp