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

1 vote225 views1 answer
Regular expression in sql server
SQL
16 votes220 views2 answers
Add column if not exists mysql
SQL
0 vote219 views1 answer
Mysql beautifier terminla
SQL
19 votes212 views6 answers
What is mySQL
SQL
1 vote169 views1 answer
Oracle character set
SQL
0 vote216 views1 answer
Mysql cast null to string
SQL
0 vote178 views0 answer
How to connect to datbase in springboot
SQL
5 votes210 views1 answer
Mysql change primary key
SQL
0 vote226 views3 answers
Sql server import json
SQL
0 vote186 views2 answers
Sql update from two different database
SQL