update 资产负债表 set 现金及现金等价物 = b.金额 from 资产负债表 as a,
(select sum(isnull(本期借方余额,0)-isnull(本期贷方余额,0)) as 金额
from 科目余额表 where 会计期间 = @kjqj and
科目代码 >= 101 and 科目代码 <= 111)
as b where a.会计期间 = @kjqj
(select sum(isnull(本期借方余额,0)-isnull(本期贷方余额,0)) as 金额
from 科目余额表 where 会计期间 = @kjqj and
科目代码 >= 101 and 科目代码 <= 111)
as b where a.会计期间 = @kjqj
资产负债表.现金及现金等价物
=
求和(科目余额表.本期借方余额)
-
求和(科目余额表.本期贷方余额)条件:
资产负债表和科目余额表的“会计期间”等于同一个值(@kjqj)
科目余额表的“科目代码”从101至111。