SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
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  

Starting Member

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

Very Important crosS Applying yaK Herder

52326 Posts

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


SQL Server MVP

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.16 seconds. Powered By: Snitz Forums 2000