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 |
|
carin_lotan
Starting Member
3 Posts |
 Posted - 2014-11-24 : 05:54:06
|
| HelloI have been asked to write a query on SBO.It requires (among other) a reference to a budget, which does not exist anywhere now.It is a yearly budget that changes quarterly.I suppose I could add a table and update the no. each quarter - but will the history be kept?What would you recommend?Also, they require a quarterly comparison (all in the same report) is it possible for the user to enter a range of date (for sales data, for example) and also receive the data for that range only last year's?I would appreciate your reply.Carin |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-24 : 09:00:13
|
| 1. What is SBO?2. There's no budget? What kind of business operates without a budget?3. If there's a yearly budget (aha! so there IS a budget), why does it change quarterly?4. History will be kept if you keep it.5. Can't really recommend anything here. You've give far too little information (remember, we don't know about your business or database)6. It is possible to get a quarterly comparison report depending on your database |
 |
|
|
carin_lotan
Starting Member
3 Posts |
Posted - 2014-11-24 : 09:11:44
|
| Sorry - SBO is Sap Business One.We import and distribute beer and work with Microsoft SQL 2012It appears it is not a budget but sales goals per item.The report should get sales by dates, same time frame a year ago, sales goals for that time and some other information that is quite straight forward.Thanks! |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-24 : 09:15:19
|
| OK -- perhaps you should be posting in an SAP forum? |
|
|
|
carin_lotan
Starting Member
3 Posts |
Posted - 2014-11-24 : 09:36:53
|
| I am sure this forum has far better knowledge of querying than SAP forums. |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-24 : 10:10:35
|
| Well then, post the DDL for the tables you will be querying and some samples of the output you want and let's get started! |
|
|
|
|
|
|
Query