Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carl P. Anderson Concatenating Rows RE: Concatenating Rows
lilian.bu
Newbie
Points: 5
More actions
August 15, 2011 at 11:39 pm
#1368934
solution 3
select LEFT(concatenations,len(concatenations)-1) from
(select (select cast(name as varchar)+','from fruit order by id for xml path('')) as concatenations)a