[SELECT] 여러행의 결과값을 한 줄로 출력하기

SELECT NM_USER
FROM WEB_Z_MNSOFT_MO_L
WHERE CD_COMPANY = 'MN_WEB' 
AND NO_MO = 'WRN20131200055'

 

 

 

 

 

DECLARE @RESULT varchar(max)
SET @RESULT = ''

SELECT @RESULT = @RESULT + ',' + NM_USER
FROM WEB_Z_MNSOFT_MO_L
WHERE CD_COMPANY = 'MN_WEB'
AND NO_MO = 'WRN20131200055'

 

SELECT SUBSTRING(@RESULT, 2, LEN(@RESULT) - 1)  AS NM_USER