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

  • steve.pantazis (1/7/2013)


    ........ Long story short, we need to rewrite our aggregation routines, and it looks like you're pointing us in the right direction.

    Steve

    I would entirely agree with your comment and suggest you read and reread the article in question.

    I am sure that you will be able to increase performance.

    regards

    ps....whilst the solution I provided may work...I wouldnt be looking to implement in production :-)...was only suggested to get the discussion going some more...both to help you and to assist my own learning.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day