July 16, 2013 at 3:08 am
Does SQL 2014 still support "Quirky Update" ? or is this hole sealed with "QuickFix" ? 🙂
karthik
July 16, 2013 at 3:45 am
So far I have no reason to believe the quirky update is gone. And I don't think it will dissapear soon.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 24, 2013 at 3:50 am
With SQL Server 2012, there is no longer need for the Quirky update, since the windowed functions supports window framing.
N 56°04'39.16"
E 12°55'05.25"
August 16, 2013 at 4:36 am
karthik M (7/16/2013)
Does SQL 2014 still support "Quirky Update" ? or is this hole sealed with "QuickFix" ? 🙂
No-one knows, because SQL Server 2014 has not been released yet. It may work in CTP 1 (I haven't tried it) but anything could happen between now and RTM. As Peter says, there is little need for it since SQL Server 2012 has direct support for running totals (and the like) using syntax like:
SELECT
SUM(some_value) OVER (
PARTITION BY some_thing
ORDER BY some_id
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
FROM SomeTable;
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply