COALESCE in SQL Server

I have Employee table and records will look like as below.

 
One of my colleague raised me a very good question how can we show all employees
with comma separated in a single row.
Like as below.

 

Yes we can do it we have “COALESCE” in SQL Server.Here is solution

If we will see very carefully “COALESCE” is pretty much like CASE expression in SQL.

That’s It
Enjoy Reading.