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
 General SQL Server Forums
 New to SQL Server Programming
 Query

Author  Topic 

carin_lotan
Starting Member

3 Posts

Posted - 2014-11-24 : 05:54:06
Hello
I 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
Go to Top of Page

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 2012
It 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!
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page

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!
Go to Top of Page
   

- Advertisement -