Accountant's Dream - TSQL Coding Technique To Help Solve Consolidation Discrepancies
This video shows you code that you can use to identify rows that make up an aggregate. In other words, lets say you have two reports from the same data and they should equal the same total. But they don't. They have a difference in their totals of some number, say 54.56. Well this program goes through a select set of data rows and presents you the combination of rows that add up to 54.56. In some cases, this can save you days of suffering in your consolidation process.