SELECT *,(select sum(JE-SSJE-YHJE+QCQK+TZJE) from #KH2SDMXTmpTable2 where KHDM=t.KHDM AND SUBKHDM=T.SUBKHDM and ROWNO<=t.ROWNO) AS LJQK FROM #KH2SDMXTmpTable2 T