Jeff Moden (2/1/2009)
Like I said, wait until they fix the very well documented SUM() OVER... lot's of people are gonna have to fix a lot of code just as if an undocumented feature had changed. 😉
Depends how they 'fix' it. If they leave the ORDER BY optional (contrary to the other windowing functions) and ensure that the default behavior remains as it is now, then there shouldn't need to be any code changes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability