SQL Stauff用法

SQL Stauff用法

要求：查询数据信息，合并子表的文件名称字段，用逗号隔开

数据库查询NCC主表，关联文件上传子表
Select SerialNumber,ProcessStartDate,LastApproveDate,su.ChineseName as RequestUserADAccount,DepartmentChineseName,Title,
Stuff((Select ‘,’ + [FileName] From BizNCC_FileItem Where NCCID=ncc.ID For xml path(’’)),1,1,’’) as FileNameList,
Reason,ChopCount,OtherContent,
CASE When ProvideOriginal =1 Then ‘YES’ ELSE ‘NO’ END AS ProvideOriginal, PostBackAddress
From BizNCC as ncc left join SystemUser as su on ncc.RequestUserADAccount=su.ADAccount
Where Status<>‘Draft’ And Status<>‘Cancelled’