|
|
-
WayneS Commented 2 Years ago through Puzzles
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
|
-
WayneS Commented 2 Years ago through Puzzles
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
|
-
WayneS Question Asked 2 Years ago through ASK
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...
|
-
WayneS Posted 2 Years ago through Ask
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
...
|
-
WayneS Solved 2 Years ago through Puzzles
Modified for ordering of result set. Still a single, simple select statement with no CTEs.
|
-
WayneS Commented 2 Years ago through Puzzles
Modified for ordering of result set. Still a single, simple select statement with no CTEs.
|
-
WayneS Solved 2 Years ago through Puzzles
Modified to handle change in ordering requirement. Still one simple select, no CTEs...
|
-
WayneS Solved 2 Years ago through Puzzles
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.
|
-
WayneS Commented 2 Years ago through Puzzles
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.
|
-
WayneS Solved 2 Years ago through Puzzles
Performs running total of your account, as per guidelines. One simple select statement, no CTEs.
|