Blog

SELECT order_no, m_id, STUFF(
    (SELECT ',' + regdate 
     FROM INFORMATION_SCHEMA.COLUMNS 
     WHERE TABLE_NAME = 'schedule_tbl' 
     ORDER BY regdate 
     FOR XML PATH('')), 
     1, 1, '') AS regdates
FROM 
    schedule_tbl 
WHERE 
    order_no IN('NW240313151600493301','NW240313151600490302') GROUP BY order_no, m_id, regdate