LISTING 2: Getting the Balances of Branch 5 and Children from the Journal Table

CREATE  TABLE #Holder(SerialNo INT,No INT, Head VARCHAR(300) )
EXEC ExpandHierarchy 5
--Select * from #Holder
SELECT a.No,a.Head,a.SerialNo,
	(SELECT SUM(b.Dr-b.Cr) FROM Journal b WHERE a.NO=b.Ac_No) AS sum
	FROM #Holder a
	ORDER BY SerialNo