something along the lines of...

Declare @assignTo nvarchar(4000)

select @assignTo = Coalesce(@assignTo + ', ', '') + CAST(Name as nvarchar(250))

from

table2

where

...

Select @assignTo

but fair warning that won't work in a subquery..to use it in a correlated subquery you'll have to write it into a UDF with table access.

Umm....as far as I know. It's been a while.