SQL Server: How to select table rows in one line?

This is a very good article for an easy way to convert rows in a table to linear data. For instance in CRM if you have multiple rows for Contact languages, you can write a select statement and who all the languages attached to a contact in one row with commas:

http://sqlwhisper.wordpress.com/2013/03/24/stuff-and-for-xml-path-for-string-concatenation/