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)

insert into...