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

3 votes139 views2 answers
Sql select data from last week
SQL
1 vote156 views2 answers
Mysql does sentance contain word
SQL
0 vote131 views4 answers
Restart MySQL
SQL
0 vote135 views2 answers
Mysql get routine parameter list
SQL
1 vote134 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
2 votes131 views2 answers
Sql first character
SQL
0 vote145 views1 answer
Sql max of two values
SQL
8 votes153 views2 answers
How to fetch data from database without last column
SQL
0 vote138 views1 answer
Get time component of datetime sql
SQL
0 vote131 views1 answer
Mysql select all where count more than"
SQL