记STUFF函数注意点

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

记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

本文2024-09-16 17:28:57发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-15992.html

阅读排行