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 vote125 views2 answers
Oracle create synonym
SQL
0 vote151 views1 answer
SQL check if record exist
SQL
-1 vote125 views1 answer
Select first rows postgresql
SQL
0 vote131 views1 answer
Get date ISO in psql
SQL
5 votes140 views1 answer
Oracle list functions
SQL
17 votes131 views3 answers
Postgresql version command
SQL
11 votes127 views1 answer
Ddl materialized view
SQL
1 vote125 views1 answer
Sql drop with dependencies
SQL
0 vote123 views1 answer
Pip install mysqlclient error
SQL
0 vote81 views1 answer
Split a string with expression and get the last value of split sql
SQL