Database

GetAccount_ID

DECLARE GetAccount_ID  CURSOR STATIC FOR
SELECT Account_ID FROM AccountTree WHERE Account_ParentID = @AccountID AND Account_Isleaf = 0

WITH cteAccountTree As
(
    SELECT
        @AccountID As Account_ID

    UNION ALL

    SELECT
        P.Account_ID
    FROM
        cteAccountTree As P
        INNER JOIN AccountTree As C
        ON C.Account_ParentID = P.Account_ID
    And
        Account_Isleaf = 0
)
SELECT
    @TotalValue = IsNull(Sum(JournalDet_Debit), 0) * CASE WHEN @Currency = 0 THEN AccountBranch_CurrencyConv ELSE 1 END
FROM
    cteAccountTree As T
    INNER JOIN Account_InBranch As B ON B.AccountBranch_AccountID = T.Account_ID
    LEFT JOIN Journal_Details As JD ON JD.JournalDet_AccountID = T.Account_ID
    LEFT JOIN Journal_Head As JH ON JH.Journal_ID = JD.JournalDet_HeadID
WHERE
    Journal_BranchID = @Branch
And
    Journal_Date Between @DateFrom And @DateTo
;

<hr size="1" color="#63B4FF" noshade="">
  <span style="color: rgba(0, 88, 170, 1)">
    <cite>"These people looked deep within my soul and assigned me a number based on the order in which I joined."</cite>
     - Homer
  </span>

• You get the total for account A;
• You then loop through the child accounts:
  
  
  • You get the total for account A.1 and its parent account (account A), and add it to the total;
  • You get the total for account A.2 and its parent account (account A), and add it to the total;
• Etc.