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

6 votes194 views2 answers
Mysql interval 1 day
SQL
2 votes178 views1 answer
SELECT INTO
SQL
0 vote181 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote234 views1 answer
Download mysql database to excel in android studio
SQL
0 vote183 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote234 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote193 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote251 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote200 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote210 views3 answers
How to pass password to mysql command line
SQL