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 vote315 views1 answer
What is the use of index in mysql table
SQL
0 vote361 views1 answer
How to find all children of a record with only parent ID in sql
SQL
7 votes330 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
3 votes336 views3 answers
Order by postgres
SQL
0 vote345 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
2 votes331 views1 answer
Mysql change data type of column
SQL
0 vote305 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote346 views1 answer
Procedure excute monthly oracle
SQL
4 votes294 views1 answer
Mac install mysql
SQL
2 votes318 views1 answer
Sql server find table name
SQL