Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield The OVER Clause enhancements in SQL Server code named “Denali”, CTP3 RE: The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

  • August 25, 2011 at 6:36 am

    #1373092

    augustine.damba 67604 (8/24/2011)

    Hi,

    Could you please verify that the Select statement and the Over() is correct for

    SumByRows and SumByRange?

    The Over() function is using same parameters but the results are different.

    I have not yet installed Denali so I cannot test this on my PC.

    Take a closer look... the parameters are not the same. The SumByRows is using "ROWS UNBOUNDED PRECEDING", and SumByRange is using "RANGE UNBOUNDED PRECEDING"

    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