之前网上查询SQL Server上如何可以用SQL合并联结多条记录中的指定字段字符串。 并按照介绍的语法结构写下了以下这条SQL句式。 但是运行报错。
求大神解惑,帮忙看看该如何纠正。 谢谢!
SELECT b.ProjectId,
left(CommentList,len(CommentList)-1) as FlowComments
from (select ProjectId, (select ApproveStatus + ',' from "KMS_Business_DB".dbo."KPMS_V_Report_Flow" where ProjectId = a.ProjectId FOR XML PATH('')) AS CommentList from "KMS_Business_DB".dbo."KPMS_V_Report_Flow" a where FlowName in ('H岗审批','G岗审批') and not isnull(ApproveStatus) group by ProjectId) b;