DEFINITIONS

Definitions More Info.
Definition ID588
TitleSQL
CategoryNOTES
DefinitionPartitionSorgulama
Definition DescriptionSELECT $partition.TESTQUARTERPFNC(RecordDate) AS [Partition Number] , min(RecordDate) AS [Min Order Date] , max(RecordDate) AS [Max Order Date] , count(*) AS [Rows In Partition] FROM Customer1 C WHERE $partition.TESTQUARTERPFNC(RecordDate) IN (2,3,4,5,6,7,8,9,10,11,12,13)-- Partition sıra numarası GROUP BY $partition.TESTQUARTERPFNC(RecordDate) ORDER BY [Partition Number] GO
RecordBycunay
Record Date26-09-2014 12:16:26
Düzenle
Kopyala
Sil