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 vote357 views2 answers
How to create a table from another table in sql derby
SQL
0 vote365 views1 answer
Incorrect string value: mysql
SQL
0 vote396 views1 answer
Stored procedure function relation
SQL
0 vote344 views1 answer
Mysql trim characters
SQL
3 votes365 views1 answer
Sql replace character in string in all records
SQL
0 vote356 views1 answer
Drop constraint in ms sql
SQL
4 votes343 views1 answer
Oracle user tables
SQL
5 votes359 views6 answers
Sql foreign key
SQL
11 votes391 views5 answers
Laravel db facade
SQL
21 votes350 views3 answers
Sql average
SQL