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 vote111 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote124 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote118 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote112 views1 answer
Mac os zsh: command not found: mysql
SQL
-1 vote169 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote154 views1 answer
Oracle db timestamp auto add
SQL
0 vote151 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote126 views1 answer
Trigger vérifier stock
SQL
6 votes120 views5 answers
Mysql get last insert id
SQL
-1 vote116 views1 answer
Insert results of a stored procedure into a temporary table
SQL