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 vote308 views1 answer
Oracle table privileges
SQL
7 votes316 views1 answer
Oracle pagination query rownum
SQL
0 vote281 views1 answer
Sql remove last 2 digit
SQL
3 votes294 views1 answer
Query less than datetime sql
SQL
0 vote283 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
6 votes247 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote289 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote284 views1 answer
Get the previous column of a table in mysql
SQL
11 votes279 views2 answers
Set default column value sql
SQL
11 votes301 views2 answers
You are using safe update mode
SQL