Home Forums SQL Server 2008 SQL Server 2008 - General place all rows into one row RE: place all rows into one row
wdmm
Old Hand
Points: 311
More actions
April 29, 2016 at 9:50 am
#1875633
think this will work:
select replace(stuff((select ' ' + oap from @OAP for xml path('')),1,1,''),'</br >', '</br>')