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 vote147 views2 answers
Unique key
SQL
0 vote130 views1 answer
Oracle query archivemode
SQL
3 votes149 views1 answer
Oracle apex message quit website
SQL
1 vote155 views1 answer
Mysql select all and rename one
SQL
9 votes124 views2 answers
Get first 3 letters in sql
SQL
0 vote137 views1 answer
Power query datetime to date
SQL
0 vote135 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote131 views1 answer
Mysql find db contarint
SQL
3 votes134 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote170 views1 answer
How to connect to xampp sql server on windows cmd
SQL