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 vote259 views1 answer
How to tell if i have lactose intolerance
SQL
-3 votes333 views8 answers
Sql to c# linq converter online
SQL
0 vote260 views1 answer
Import excel to sql
SQL
0 vote255 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote243 views1 answer
Mysql error codeigniter
SQL
2 votes259 views4 answers
2nd highest salary in mysql
SQL
0 vote253 views1 answer
Sqlite commands
SQL
0 vote208 views1 answer
Oracle sql developer script output limit
SQL
8 votes274 views3 answers
SQL column name
SQL
0 vote282 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL