[MSSQL] 서브쿼리를 문자열로 합치기 (using xml path)

SELECT
  ',' + CODE_NAME
  FROM TCODE01TT T1
  WHERE SEX = 'M' AND BOKJONG = 'J' AND S_CODE = '1'
  FOR XML PATH('')