Blog Pages

$PARTITION

SELECT $PARTITION.pf_Orders(OrderDate) AS Partition, 
COUNT(*) AS [COUNT] , Min(Orderdate) [from], Max(OrderDate) [to]
FROM dbo.NewSales 
GROUP BY $PARTITION.pf_Orders(OrderDate)
ORDER BY Partition

No comments:

Post a Comment