Seems like a complicated way to reach the end goal.

I agree with the earlier post.. I'd do it like this:

declare @Tmp Table (name varchar(10), id int)

DECLARE @TEXT varchar(Max)...