--把出多条备注信息拼成一个字符串,每条备注用“;”隔开
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

