SQL SERVER: Get Comma Separated List with SELECT statement

Today I have the following situation, where I need to display all related data in comma separated list. Till today we are using scalar function to display Comma separated list with select statement. That scalar function use the COALESCE() to make comma separated list. Today I found wonderful solution to display comma separated list without scalar function. Let see that