Viewing 2 posts - 1 through 2 (of 2 total)
1) Bummer, I was just gonna use the stuff... Need a book!!
2) SELECTBusinesID,
AreaID,
DATEPART(yy, GetDate()) AS [Year],
SalesYTD,
AVG(SalesYTD) OVER (PARTITION BY AreaID ORDER BY DATEPART(yy, GetDate())) AS MovingAvgYTD,
SUM(SalesYTD) OVER...
December 5, 2013 at 4:21 pm
#1671338
This worked for me! Thanks a bunch.
Robb
December 7, 2012 at 3:07 pm
#1566782