For an example of what I'm trying to do and the method I used, please see http://www.projectdmx.com/tsql/rowconcatenate.aspx

I followed the example under the Recursive CTE methods.