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 vote181 views1 answer
Mysql url data type
SQL
0 vote182 views1 answer
Sql combine results from two tables
SQL
0 vote182 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote176 views1 answer
Luu ckeditor vao mysql
SQL
0 vote186 views1 answer
Template MySQL Zabbix agent
SQL
6 votes198 views3 answers
Update with inner join postgres
SQL
35 votes198 views5 answers
Sql alter column
SQL
-1 vote185 views1 answer
Mac mysql workbench console
SQL
0 vote183 views1 answer
Query archive mode
SQL
3 votes176 views2 answers
Sql get month name
SQL