Thanks. That gave me all rows in one so I changed the where clause and now it is accurate.

Select STUFF(

(SELECT ...