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 vote186 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote184 views1 answer
How to add timestamp column in mysql
SQL
4 votes199 views3 answers
Drop Table Oracle
SQL
0 vote224 views1 answer
Many rows to 1 string mysql
SQL
0 vote183 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote189 views1 answer
Interview experience as a call?
SQL
2 votes199 views1 answer
Install postgresql centos 5
SQL
0 vote185 views1 answer
Normalization in database
SQL
25 votes192 views5 answers
Date in mysql
SQL
0 vote729 views1 answer
Sql show table name in result
SQL