Jacob, A testing question... were all submissions tested on this new Denali server, or just mine (it wouldn't seem a fair comparison if just mine)? The Performance Testing Comparison page implies that they were all tested on 2008 RTM (which this solution

I actually thought that my entry would be disqualified because it specified a SQL Server version not yet RTM. For how ROWS UNBOUNDED PRECEDING works, see [my article][1]. FYI: you might be interested in a performance test I did of running totals in D

Hey Jacob: 1. I submitted an entry to a contest, but didn't want others to see it - and I forgot to check the checkboxes. How do I fix this? 2. How do I delete older submissions that have a newer answer? Thanks, Wayne...

Hey Jacob: 1. I submitted an entry to a contest, but didn't want others to see it - and I forgot to check the checkboxes. How do I fix this? 2. How do I delete older submissions that have a newer answer? Thanks, Wayne ...

Modified for ordering of result set. Still a single, simple select statement with no CTEs.

Modified for ordering of result set. Still a single, simple select statement with no CTEs.

Modified to handle change in ordering requirement. Still one simple select, no CTEs...

Modified original entry based upon clarifying data ("Running total should be calculated PER CUSTOMER. type PAY should be subtracted from the total.... ") Still one simple select statement, no CTE.

Modified original entry based upon clarifying data ("Running total should be calculated PER CUSTOMER. type PAY should be subtracted from the total.... ") Still one simple select statement, no CTE.

Performs running total of your account, as per guidelines. One simple select statement, no CTEs.