Hi r987d,
If you download the link at the end of the article, it has the data used for the example and all the queries step-by step.  
m

rchantler,
R would be a brilliant approach and probably much easier to implement.  If you google forecasting + R or linear regression + R you'll come up with a lot...

Last 3 dates for each month in a calendar table

WITH dates as (

select

dateId

, calendarMonthName

, ROW_NUMBER() over (partition by calendarMonthName order by dateId desc) as id

from DimDate

where calendarYear = 2013

)

SELECT...

Kraig - I completely agree. In an ideal scenario, you...

There are a variety of reasons not to develop on a shared database. As others have already mentioned, when you are developing locally you can avoid all sorts of...

Yes. That should work fine for you to give a directional insight into your data. Products, customers or risk types are simply discrete values by which to partition the forecast...

Hi Grasshopper,

I do not have any examples of weighted averages, but you may considering looking at exponential smoothing which weights, more heavily, recent periods.

I do suggest making sure...

ltaylor 73774 (2/11/2010)

---

Very good article, thanks. When I picked up the code snippet and tried to use it, I saw one problem. In the last section of code, labeled "Create...

Thanks for the clarifications, Al. I appreciate the finer points and I am sure this will be helpful to any readers as well.

Mark

Hi Martin,

I appreciate your comments and words of pause. It is important to realize that picking up this forecast model will not get you a job as a forecaster...

Hi,

I see this is a very old thread, but I have a similar issue and replacing the partition does not resolve the issue. In my case, I have...

Gail and Jeffery, In understand and agree with much of what you have to say. Regarding frequent backups of the log file, this really does not make a difference...

Hi - I know this topic is a little dead, because it was posted in February, However I am going through this same problem now as we just completed a...

Hi Brian, Great Article. I just spent the last week setting Kerberos up so this is really synchronicity that this topic is showing up today. You explain it...