I find the use of XMl to be a cleaner method to concatenate rows into a single value:

select Fname+','

From Employee

For XML Path(''), Type