通过sql的stuff 把一列几行的记录拼接在一行一个字段
---通过sql的stuff 把一列几行的记录拼接在一行一个字段 select FID,a.FCustomerID as 工地ID , 应验收节点 = (stuff((select ',' + isnull(t2.FName,'') from MD_ProjectPlanEntry t1 inner join MD_BaseData6_L t2 on t1.FGCJDXM=t2.FID where t1.FID=a.FID and convert(varchar(6),t1.FPEDATE,112)<=convert(varchar(6),getdate(),112) and FAEDATE is null for xml path('')),1,1,'')) , 实际验收节点 = (stuff((select ',' + t2.FName from MD_ProjectPlanEntry t1 inner join MD_BaseData6_L t2 on t1.FGCJDXM=t2.FID where t1.FID=a.FID and convert(varchar(6),FAEDATE,112)=convert(varchar(6),getdate(),112) for xml path('')),1,1,'')) from MD_ProjectPlan a group by a.FID ,a.FCustomerID