Jason-299789 (11/7/2012)

---

You might want to look at this thread as its very similar to what you want to do,

http://www.sqlservercentral.com/Forums/Topic1379719-391-1.aspx

The only difference is the source table and column names and the format of the output string in the CTE, so you should be able to recode this to suite your requirements.