펌) select row 합치기
펌 ) http://jjun7983.tistory.com/211 SELECT DISTINCTSTUFF((SELECT merge_column + '^'FROM table_nameWHERE where_column = '10'FOR XML PATH('')),1,0,'') ASFROM table_namemerge_column : 합쳐야 할 컬럼where_column : 조건 컬럼table_name : 테이블명결과 : column^column^column
