Forecasting/Trending data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Forecasting/Trending data

Author

Topic

Brittney10
Posting Yak Master

154 Posts

Posted - 2010-11-04 : 10:41:04

I'm wondering if one can do forecasting/trending using a SQL query. I know I can just pull the data down into Excel and trend the data that way, then import it back into SQL, but I want to automate this process. So Excel isnt a viable option for me.

I have the following columns for my table:

Name, Data, Month

So my data would look something like this (for example):

Jane 1000 Jan
Jane 2000 Feb
Jane 3000 Mar
Jane NULL Apr
Jane NULL May
Jane 5000 Jun
Jane 1000 Jul
Jane 2000 Aug
Jane 2300 Sept
Joe 1000 Jan
Joe 2000 Feb

.....and so forth

Now i want to forecast/trend that data out about 6 months. Any ideas??? Any help or suggestions would be much appreciated.

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-11-04 : 11:44:08

yes it can be done.

1. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=123885&SearchTerms=trend
2. http://www.mahipalreddy.com/blog/?p=110 Search for automating Excel from SSIS

If you don't have the passion to help people, you have no passion