WITH music AS ( SELECT 1 music_id, '너의 의미' music_name ) , iu AS ( SELECT 1 music_id, 1 idx, 0 data_d UNION ALL SELECT 1, 2, 0 UNION ALL SELECT 1, 3, 0 UNION ALL SELECT 1, 4, 0 UNION ALL SELECT 1, 5, 0 UNION ALL SELECT 1, 6, 0 UNION ALL SELECT 1, 7, 0 UNION ALL SELECT 1, 8, 0 UNION ALL SELECT 1, 9, 0 UNION ALL SELECT 1, 10, 0 UNION ALL SELECT 1, 11, 1 UNION ALL SELECT 1, 12, 0 UNION ALL SELECT 1, 13, 0 UNION ALL SELECT 1, 14, 0 UNION ALL SELECT 1, 15, 0 UNION ALL SELECT 1, 16, 1 ) SELECT m.music_id , m.music_name , STUFF((SELECT CAST(data_d AS VARCHAR) FROM iu WHERE music_id = m.music_id ORDER BY idx FOR XML PATH('') ), 1, 1, '') music_number FROM music m WHERE music_id = 1 ; http://www.gurubee.net/article/55512