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 |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2004-05-20 : 16:58:40
|
| Hey all-I’ve got to do some computing with our budgets vs. actual and am wondering what is the best way to store these? Right now the budgets are in excel, so that part will have to be inputted. I’ve talked myself in and out of storing these in the same table as the actuals at least four times for query reasons. Any helpful insight as to which way maybe better?They are pushing for an Estimate At Completion report. It reminds me of a progress report on a project. For example. A program manager has a project to build five robots over the next 3 years. He sets up his budget for three years and then a few months into it he wants to know how much he has spent so far and how much of his budget he has left and of course where he has went over. Does that make sense? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-05-20 : 17:42:53
|
| Initially, my thought is to store them in the same table, but not side-by-side within the same row. Instead, create an attribuate of Budget vs. Actual. But then as I look at it, I think the decision needs to be based on other business rules such as how often will you report on only budget or only actuals vs. how often do they need to be reported side-by-side? And is there the option for multiple budgets? Or maybe estimated budget needs? Basically, I'm saying will you need multiple versions of either budget or actual? I could easily argue keeping them in separate tables.In general, I resist making two (or more) tables that are nearly identical except for a categorization or an optional field. You can keep them in the same table, but distinct rows and do your JOINS with additional criteria in the JOIN clause (hey, that sounds like the name of an article).--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
|
|
|
Budget vs actuals - seprate tables?