declare @t table(itemid int,val nvarchar(4000)) insert into @t(itemid,val) select itemid,'<img id="img' + ltrim(rtrim(id)) + '" src="' + SignFile + '" style="150px">' from TableName select * from @t SELECT itemid,value=STUFF(( (select val from @t --where Filetype=@Filetype and Fileid=@Fileid and Templateid=@Templateid and nodestate>0 FOR XML PATH(''),type).value('.','NVARCHAR(MAX)') ), 1, 0, '') FROM @t group by itemid