I'm trying to peek orders from the last year but it doesn't work.
Max(Year([Order Date])) As MaxOrderYearByOrder
FROM [..\Qvd\FactOrders_6_Import.Qvd] (qvd)
Group By [Order ID];
Someone can explain me why ?
*It must be in the ETL process
Above code gives you most recent order of evrey order id.
If you are pointing to last year then it has to be in where year(OrderDate)=(Year(today())-1)
This is not what I mean.
Retrieving data ...