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 |
|
scripter
Starting Member
49 Posts |
 Posted - 2010-05-19 : 21:19:56
|
| Ok I have for the last couple of years been keeping tracked of my bills using an excel spreadsheet which has been good to me but I am wanting a bit more that I am just not going to get from excel so I decided I am going to build a webpage for me to access that will allow me to see what payments I need to pay how much money will I have left ect...So my big issue at the moment is honestly database design. I initially dove right in thinking this is going to be easy and started designing the tables well I have found that this is not as easy as I thought.Sou here is the basics of the tables.Table = ToPayColumns = ID, Payee, DueDay, PayAmountTable = PayCheckDaysColumns = ID, PayDateSince I know what day of every month I pay my Cell phone bill I should be able to store that as simply 5 for the fifth of the month.So if today is the 1st and I get paid on the 3rd I should be able to run a query that calls getdate() to determine what todays date is and compare it to see when the next payday is and what bills are due between that day and the payday after that. I am going to leave it there as I do not want to try to get to complicated in the explanation if I do not need to. If you do need more explanation let me know and I will try to get a bit more descriptive |
|
|
|
|
|
BiWeekly Bills on a BiWeekly Paycheck