Ladies and Gentlemen,
This article is in the process of a rewrite because of the impact that SQL Server 2005 had on the ORDER BY method for the running totals. The "quirky" update method still works as advertised, but if you have used the ORDER BY method, you need to make some serious changes to guarantee the correct update order.
The new article will be published with the same URL so as not to break anyone's links.
Heh.. the ironic part is that the very well documented ORDER BY method no longer works and the supposedly undocumented "quirky" update still does. Go figure.
I appologize for the inconvenience but, again, if you used the ORDER BY method, please immediately check your results and make sure that it still works like it did in SQL Server 2000. Even if you're still running in SQL Server 2000 and installed SQL Server 2005, the ORDER BY method may still have gone sour like it did on my machine.
Steve, can you make sure "this" warning replaces the current article? Thanks.
--Jeff Moden
