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 vote365 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote389 views1 answer
Drop a view in sqlite
SQL
0 vote350 views2 answers
Mysql on update current_timestamp
SQL
0 vote315 views1 answer
How to get n result in sql
SQL
0 vote351 views1 answer
How to make full text search dynamic in mysql
SQL
5 votes391 views1 answer
Oracle get ddl
SQL
0 vote365 views1 answer
Login failed for user sql server
SQL
3 votes337 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote344 views1 answer
Sql add calculated column
SQL
0 vote344 views1 answer
Linebreak sql
SQL