Comma seperated join mssql

select SM.ROLLNO,
       SM.NAME, 
       SM.ADDRESS,
       (
       select ','+CM.CourseName
       from dbo.CourseMaster as CM
       where ','+SM.Course+',' like '%,'+CM.CourseId+',%'
       for xml path(''), type
       ).value('substring(text()[1], 2)', 'varchar(max)') as Course
from dbo.StudentMaster as SM;

Source: dba.stackexchange.com

Similar codes

0 vote176 views1 answer
Faire une recherche par liste de mot clé sql
SQL
3 votes174 views2 answers
Mysql time
SQL
0 vote195 views1 answer
Hour and minute between two datatime sql
SQL
1 vote180 views1 answer
Where to locate set password for mysql
SQL
10 votes183 views4 answers
Join with multiple conditions sql
SQL
0 vote181 views1 answer
GROUP BY postgres
SQL
0 vote174 views1 answer
Mysql sum with group by
SQL
0 vote180 views1 answer
How to check which table has data in mysql
SQL
0 vote170 views1 answer
Access mysql database docker container shell
SQL
0 vote171 views1 answer
Frename oracle
SQL