How do I format a number with commas in T-SQL?

http://stackoverflow.com/questions/4377352/how-do-i-format-a-number-with-commas-in-t-sql