select JZRQ AS 日期, SY AS 实_预, Fname_l3 AS 预算单元, Fnumber_L3 AS 科目序号, fname_l4 as 科目名称, sum(JE) as 金额, SFSS , SFGB , brNumber as 品牌编码, brName as 品牌, prtNumber as 产品编码, prtName AS 产品, seaNumber as 期数编码, seaName as 期数, FPeriodNumber as 会计期间, FORMAT(CONVERT(date, JZRQ + '-01'), 'yyyy"年"M"月"') + GSBM AS 匹配项主体 from DM.dbo.T_PP_KB where SFGB='是' and JZRQ ='2024-02' and Fname_l3 LIKE '%事业部%' and SY ='实' group by JZRQ, SY, Fname_l3, Fnumber_L3, fname_l4, SFSS, SFGB, brNumber , brName , prtNumber , prtName , seaNumber, seaName, FPeriodNumber, GSBM 不知为什么这段SQL一直读不出来,10万行数据内,
有没办法优化一下速度 |