记STUFF函数注意点
--数据库查询 15秒
SELECT
(SELECT ISNULL(STUFF((SELECT ';'+F_PAEZ_Text1 FROM T_Cust_MoldSeriesEntry MO
LEFT JOIN PAEZ_t_Cust_Entry100027 SE ON SE.FID = MO.FMOIDSERIES AND MO.FMATERIALID = MA.FMATERIALID FOR XML PATH('')),1,1,''),'')) 系列代码,
(SELECT ISNULL(STUFF((SELECT ';'+FNUMBER FROM T_Cust_MoldTypeEntry MO
LEFT JOIN PAEZ_t_Cust_Entry100029 SE ON SE.FID = MO.FTYPECODE AND MO.FMATERIALID = MA.FMATERIALID FOR XML PATH('')),1,1,''),'')) 机型代码
FROM T_BD_MATERIAL MA
LEFT JOIN T_ORG_ORGANIZATIONS_L ORGL ON ORGL.FORGID = MA.FUSEORGID
LEFT JOIN T_BD_MATERIALGROUP_L MGL ON MGL.FID = MA.FMATERIALGROUP1
WHERE FUSEORGID IN (1065512,1065513) AND FMaterialGroup1 != 0
ORDER BY ORGL.FNAME desc
--数据库查询 1秒
SELECT
(SELECT ISNULL(STUFF((SELECT ';'+F_PAEZ_Text1 FROM T_Cust_MoldSeriesEntry MO
LEFT JOIN PAEZ_t_Cust_Entry100027 SE ON SE.FID = MO.FMOIDSERIES WHERE MO.FMATERIALID = MA.FMATERIALID FOR XML PATH('')),1,1,''),'')) 系列代码,
(SELECT ISNULL(STUFF((SELECT ';'+FNUMBER FROM T_Cust_MoldTypeEntry MO
LEFT JOIN PAEZ_t_Cust_Entry100029 SE ON SE.FID = MO.FTYPECODE WHERE MO.FMATERIALID = MA.FMATERIALID FOR XML PATH('')),1,1,''),'')) 机型代码
FROM T_BD_MATERIAL MA
LEFT JOIN T_ORG_ORGANIZATIONS_L ORGL ON ORGL.FORGID = MA.FUSEORGID
LEFT JOIN T_BD_MATERIALGROUP_L MGL ON MGL.FID = MA.FMATERIALGROUP1
WHERE FUSEORGID IN (1065512,1065513) AND FMaterialGroup1 != 0
ORDER BY ORGL.FNAME desc
记STUFF函数注意点
本文2024-09-16 17:28:57发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-15992.html
