Another stuffing, and it's not even a holiday

Another version of the "get stuffed" script

http://raresql.com/tag/merge-or-combine-multiple-rows-records-to-single-column-record-with-comma-delimiters/

coalesce is NOT the answer

"These are not the droids you're looking for" ? ? ?

http://msmvps.com/blogs/robfarley/archive/2007/04/08/coalesce-is-not-the-answer-to-string-concatentation-in-t-sql.aspx

Short version? Use STUFF() instead.