declare @sumstring varchar(n)
set @sumstring=''

select @sumstring=@sumstring+columnname from tablename

select @sumstring