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

5 votes222 views1 answer
Ascending order and where in sql
SQL
1 vote189 views1 answer
Oracle case
SQL
0 vote184 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote244 views1 answer
Using distinct and count together in sql
SQL
2 votes226 views1 answer
Show max_allowed_packet mysql
SQL
7 votes272 views1 answer
Oracle alter sequence restart start with
SQL
1 vote198 views1 answer
Sql row having max
SQL
0 vote175 views1 answer
Oracle select invalid views
SQL
1 vote209 views2 answers
Sql queries practice
SQL
1 vote176 views1 answer
Sql server 2012 query history
SQL