Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Quirky Update in SQL 2014 Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 3:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:38 AM
Points: 2,023, Visits: 2,517
Does SQL 2014 still support "Quirky Update" ? or is this hole sealed with "QuickFix" ? :)



karthik
Post #1474034
Posted Tuesday, July 16, 2013 3:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
So far I have no reason to believe the quirky update is gone. And I don't think it will dissapear soon.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1474044
Posted Wednesday, July 24, 2013 3:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:35 PM
Points: 2,393, Visits: 3,399
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"
Post #1476949
Posted Friday, August 16, 2013 4:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 11,192, Visits: 11,090
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1485089
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse