Need help using the most efficient aggregation method in SQL Server 2008 R2 to sum up child rows in same table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Need help using the most efficient...

14 posts, Page 2 of 2

««1 2

Need help using the most efficient aggregation method in SQL Server 2008 R2 to sum up child rows in same table

Rate Topic

Display Mode

Topic Options

Author

Message

J Livingston SQL

Posted Monday, January 07, 2013 11:04 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 1,469, Visits: 14,561

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 Smile

...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 !
__________________________________________________________________

Post #1403760

steve.pantazis

Posted Monday, January 07, 2013 11:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 3:38 PM
Points: 8, Visits: 71

Yes, agreed. I have a steep learning curve ahead of me, but it's necessary. Thanks again for your contribution.

Post #1403764

J Livingston SQL

Posted Monday, January 07, 2013 11:16 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 1,469, Visits: 14,561

steve.pantazis (1/7/2013)

Yes, agreed. I have a steep learning curve ahead of me, but it's necessary. Thanks again for your contribution.

Steve

may be worth your while posting some "base data examples" here on the forum and see what the collective mindset comes back with......you never know Smile

__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________

Post #1403769

steve.pantazis

Posted Monday, January 07, 2013 11:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 3:38 PM
Points: 8, Visits: 71

That sounds good. What I will do is work on the aggregation queries and then post my solution using a sample dataset. Then the community can analyze the solution and either use the methodology to help them, or offer a more optimized method.

Post #1403773

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions