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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-05 : 09:40:06
|
| Ian writes "I have a database which will store monthly data relating to targets, the data will be used to create reports, however I now want to add the ability to add text to the reports, currently I have one table called Departments, which is related to the Targets Table (One-to-Many). The Targets table is then related to a table called Data (one-to-one). The data table has 13 columns, one ID and then ther twelve calendar months, each month the data is added to the related month. How to I change the design so I can also add comments and text along with the monthly data, should I seperate the data in to tweleve tables, one for each month?Please help its driving me nuts.I am using SQL Server 2000, Win 2000 Advanced Server. ASP and VB to query the database." |
|
|
|
|
|
Arranging monthly data into tables