两种汇总的方式
1、向左汇总
UPDATE A SET Total = ISNULL(A.a, 0) + ISNULL(A.b, 0) ;
2、向上汇总
/*要求:(1)要有规范的编码
(2)末级标识字段*/
--更新 向上汇总
UPDATE A
SET A.SumCol = ( SELECT SUM(ISNULL(SumCol, 0))
FROM A
WHERE Code LIKE A.Code + '%'
AND IsEnd = 1
)
FROM TBCS_M_FinancialList A
WHERE IsEnd = 0;--末级标识