用心,承载未来

SELECTACCOUNTCODEID, PARENTCODEID, COMPANYID, BUDGETYEAR, PLANMAINID, PLANMAINCODE,SUM(THISADJUSTMENT1) AS THISADJUSTMENT1,SUM(THISADJUSTMENT2) AS THISADJUSTMENT2,SUM(THISADJUSTMENT3) AS THISADJU...

1.根据末级递归查询出上级，形成树形结构SELECT DISTINCT ACC.ACCOUNTCODEID, ACC.PARENTCODEID, ACC.ACCOUNTCODE, ACC.ACCOUNTCODENAME,ACC.FIRSTORDER, ACC.SECONDORDER,T.PLANMAINID, T.PLANMAINNAME, T.PLANMAINCODE,'Y' AS ...

--利用with as 临时表 进行插入（修改）操作INSERT INTO TEMP_REFRESHMANAGERDETAIL (PLAZABUDGETINFOID, PLAZABUDGETID, ACCOUNTCODEID, CODEFORMAT, NFNBUDGETMONTH1, NFNBUDGETMONTH2, NFNBUDGETMONTH3, NFNBUDGETMONTH4, NF...