SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to Create and caculate Forecast Report in SQL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

caulson
Starting Member

Malaysia
1 Posts

Posted - 06/13/2012 :  01:25:04  Show Profile  Reply with Quote
HI,May i know how to create and caculate Forecast Report in SQL.

As below is my example report layout in SQL

Table 1
Date Item On hand balance Usage

10/6 book 10 3
11/6 book 7 3
12/6 book 4 3
13/6 book 1 3



Table 2

Date Item Receive On hand balance Usage

14/6 book 10 11 3






How to use SQL function to calculate a date ,on hand balance and usage ? if i receive new item how to add in On hand balance ?

thank you

Edited by - caulson on 06/13/2012 01:45:53

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/13/2012 :  10:50:08  Show Profile  Reply with Quote
see scenario 1

http://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000