Home Forums SQL Server 2008 SQL Server 2008 - General Need help using the most efficient aggregation method in SQL Server 2008 R2 to sum up child rows in same table RE: Need help using the most efficient aggregation method in SQL Server 2008 R2 to sum up child rows in same table

  • I will definitely try out your code...thanks.

    The reason for insert into ResultHistory is that we process large quantities of sales data from a detail table containing each account opening that we need to aggregate into totals each night so bankers can view the numbers via our Web app when they walk in the office the next day. We have the equivalent of a data mart that is used for tracking historical sales over time. Rather than keep the aggregated data in cubes, we prefer relational tables, which makes querying the data via stored procedures and SSRS a breeze.