1.select stuff((select ','+a.exttextfield1 from project a where ','+ b.field027 +',' like '%,'+cast(a.id as varchar(32))+',%' for xml path('') ),1,1,'') as project from ufp0w7y71553484969275 b where field027='4028e5e56a159674016a1e9f3937047e,4028e5e56a159674016a1fce85d81085' 2.select (select stuff((select ','+h.objname from humres h where ','+ b.field015 +',' like '%,'+cast(h.id as varchar(32))+',%' for xml path('')),1,1,'') as humrers from ufp0w7y71553484969275 b where b.id=uf.id) as humrers from ufp0w7y71553484969275 uf where requestid in (select id from workflowbase where isdelete=0) and field075=1 and field005>='2023-01-01' order by field005 desc
标签:humrers,ufp0w7y71553484969275,sqlserver,人员,where,id,select From: https://www.cnblogs.com/jk200/p/17728247.html