tag:blogger.com,1999:blog-9025736111713624877.post5918006210496576376..comments2023-11-09T22:36:41.805-08:00Comments on Random technical stuff: Running total in SQL Server...Ta bu shi da yuhttp://www.blogger.com/profile/00750381951662588677noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9025736111713624877.post-29811712991868944332010-07-30T03:23:45.034-07:002010-07-30T03:23:45.034-07:00Good point Jeff... I can't wait for SQL Server...Good point Jeff... I can't wait for SQL Server to get enhanced analytic functions!Ta bu shi da yuhttps://www.blogger.com/profile/00750381951662588677noreply@blogger.comtag:blogger.com,1999:blog-9025736111713624877.post-90153136590874641532010-07-29T19:28:16.079-07:002010-07-29T19:28:16.079-07:00Howdy!
You might want to check the column order o...Howdy!<br /><br />You might want to check the column order of the CTE with the SELECT list of that same CTE. ;-)<br /><br />You also might want to read the article I wrote on Triangular Joins on SQLServerCentral.com to see why that particular method for doing running totals is usually not a good idea.<br /><br />http://www.sqlservercentral.com/articles/T-SQL/61539/<br /><br />--Jeff ModenAnonymousnoreply@blogger.com