so as newbie in the top post quotes why not just use a select @var+ to concatenate.

You said it thats fine for 1 entity granted can see that.

But just move the code to a function that accepts the entity pk key and returns the concat string.

Then just call the function from a select thats listing the entities you want reporting?

somthing like,

select entkey, getmylist(entkey) from myentlist