I have the following virtual column generated from an aggregate over a sorted partition,
MIN(picture_id) OVER ( PARTITION BY [360_set] ORDER BY picture_id ASC )
However, when I execute that, I get the following.
Msg 11305, Level 15, State 10, Line 12 The Parallel Data Warehouse (PDW) features are not enabled.
This is where it gets interesting though, without a sort order on the partition, it works:
MIN(picture_id) OVER ( PARTITION BY [360_set] )
ROW_NUMBER() a window function (not an aggregate function) works with an explicit order on the partition.
ROW_NUMBER() OVER ( PARTITION BY [360_set] ORDER BY picture_id ASC )
How come the desired statement doesn't work? Where is this documented? The version information was requested, this is what I in Help → About.
Microsoft SQL Server Management Studio 10.0.5512.0 Microsoft Analysis Services Client Tools 10.0.5500.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.10.9200.16635 Microsoft .NET Framework 2.0.50727.5472 Operating System 6.1.7601
The result from
SELECT @@VERSION is
Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)