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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-07-21 : 08:20:29
|
| Hi there,I just have a quick question about developing a budgets table. It's for a financial application and the table will be budgets broken down into an area and month.I've not really done anything like this so I was wondering if anyone had any advice on what the schema should look like?The table will also be populated from an excel spread sheet. I guess the excel spread sheet should have the relevant columns that reference the tables in the db?hope someone can help.Cheers |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-21 : 08:41:35
|
| You would at least have area, month and budget amount fields, you may want to break this down further to include projects, but this can be done in another table if needed (depends on your application, are you going to push the app down so departmental managers can keep track of their remaining budget etc).You can do any calculations of remaining budget etc in stored procs/views etc.. |
 |
|
|
|
|
|
developing a table...