The CanGrow property was the culprit! Thanks!

Yes, the examples were very helpful indeed. Thank you!

THANK YOU!!

Thank you so much. That works beautifully.

I'm not familiar with XML. Could you point me to some additional resources so that I can understand what your...

Would the 'into #tbl ' above suffice? I wanted to be consistent with the #tbl referenced in the CTE query.

Sample data set:

select 'Report1' as reportID,'Browser' as RoleID, 'YChen' as User2

into #tbl

UNION

select 'Report1' as reportID,'Browser' as RoleID,'AChen' as User2

UNION

select 'Report1' as reportID,'Browser' as RoleID,'BChen' as User2

UNION

select 'Report2' as reportID,'Browser' as...

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.