总结运行平衡 [英] Summing a running balance

问题描述

我有一个包含这些列的表AccountReceivable

I have a table AccountReceivable with these columns

ID   ReceiveDate    Ref_No   Account_Code    Account_Name            Details      Debit    Credit 

1    2013-02-19              101             Account Receivable       wama        500

2    2013-02-19              101             Account Receivable       NRA                  200

我希望将余额列中的运行余额列入： -

I want to get the running balance into the balance column like:-

ID  Receiveddate Ref_no Account_Code  Account_Name   Details  Debit  Credit balance

1    2013-02-19          101                         wama      500            500

2    2013-02-19          101             A           NRA              200     300

推荐答案

从这里开始：http://www.sqlteam.com/article/calculating-running-totals [ ^ ]

嗨......

查看以下链接...



IN SQL Server ，第一行最后一列是如何添加第二行列？ [ ^ ]

小型办公室帐户的帐户计算管理 [ ^ ]



问候，

GVPrabu

Hi...
Check Following link...

IN SQL Server, First row Last Column is How to add with second row Columns?[^]
Accounts calculation for small office accounts management[^]

Regards,
GVPrabu

这篇关于总结运行平衡的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！