Running Totals Query

Question

Running Totals Query

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

Please read this article[/url] - just be sure to follow all the rules in using this form of the update statement - they must be followed or you can get erroneous results!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

erdem1973 SSCommitted Points: 1843 More actions · Answer 2

Thank you very much for your great comment.

Is it really such a complex query issue to get running totals of a table?

Regards

WayneS SSC Guru Points: 95461 More actions · Answer 3

erdem1973 (9/28/2010)
Thank you very much for your great comment.
Is it really such a complex query issue to get running totals of a table?
Regards

You're welcome.

Until Microsoft decides to fully implement the window functions, yes it is this complex.

You might want to visit this editorial

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2