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 vote382 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote402 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote452 views1 answer
Calculer pourcentage mysql
SQL
0 vote337 views2 answers
Mysql disable foreign key checks
SQL
0 vote362 views1 answer
Oracle archivelog usage
SQL
0 vote371 views1 answer
Create new schema mysql
SQL
0 vote355 views1 answer
Oserror mysql_config not found virtualenv
SQL
1 vote379 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
7 votes374 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote356 views3 answers
Postgresql crete view
SQL