把多条备注信息拼成一个字符串,每条备注用“;”隔开

--把出多条备注信息拼成一个字符串,每条备注用“;”隔开

select 备注=(stuff((select ' ; ' + remark_content

                      from ProjectRemark pjr where pjr.Project_ID= p.Project_ID

                      group by pjr.project_id,pjr.remark_content for xml path('')),1,1,'') )

from Projects p,ProjectRemark pr

where p.project_id=pr.project_id