SELECT STUFF(
(SELECT ',' + Semesters
FROM table t1
FOR XML PATH (''))
, 1, 1, '') AS Semesters from table t2
Scripts, Articles, Relevant for DBAs, Consultants, BI, Data Scientists and Developers