Google Translate:I have a table called tbl_account which has the following columns Codes, Account, Debit and Credit
I have another table where I make the records called tbl_entry, this table has the following columns id, recorddate, fk_account, Debit, Credit. This table has a reference to the tbl_account table in fk_account and Codes.
I want to update the Debit and Credit column of the tbl_account table where Codes is equal to fk_account and in turn the Debit and Credit of each superior account is updated with the sum of its child accounts
For example Codes 11111 = Debit 1000.00 Codes 11112 = Debit 2000.00 and that the superior account that would be Codes 1111 has the sum of those would be 3000.00 and that the superior account also has its total in Debit and in Credit of the child accounts such as Codes 111 = Debit 4000.00 since it would add the total of his other children which would be 1112 and 1113
Google Translate:Ummm I have tried using stored procedures
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)