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 vote107 views1 answer
Into sql
SQL
0 vote148 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote95 views1 answer
Microsoft sql server management studio clear cache
SQL
5 votes137 views1 answer
Postgresql functions
SQL
-1 vote149 views1 answer
Phinehas Psalm 106
SQL
1 vote148 views1 answer
Postgres convert date to string
SQL
0 vote142 views1 answer
Sql pad left 0
SQL
0 vote206 views1 answer
How to rename a database in tsql
SQL
0 vote148 views1 answer
Oracle enable chain
SQL
1 vote153 views1 answer
PL SQL MODIFY COLUMN NME
SQL