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.
Author |
Topic |
caulson
Starting Member
1 Post |
Posted - 2012-06-13 : 01:25:04
|
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 3Table 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 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|