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

1 vote359 views1 answer
Partition by sql server
SQL
2 votes333 views1 answer
How to search table name in stored procedure in sql server
SQL
18 votes314 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote380 views1 answer
Postgres list users and roles
SQL
0 vote351 views1 answer
To Create directory
SQL
4 votes365 views3 answers
Sql drop database if exists
SQL
3 votes653 views1 answer
Postgresql cast
SQL
13 votes374 views2 answers
Get date from now() mysql
SQL
0 vote347 views1 answer
Mysql select statement after index
SQL
0 vote342 views1 answer
Sql select rows with different values in one column
SQL