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 |
|
E7AD
Starting Member
1 Post |
 Posted - 2010-06-17 : 11:26:23
|
| Hello all:I'm trying to set up a table and I want to do it the right way so i'm looking for some advice or resources that can be of help.I want to be able to display the entries in this table based on the date and time of recorded in the entry.So as an example:Entry A only appears on Mondays at time X.Entry B appears on Tuesdays at time X and Sundays at time X.Entry C appears every day of the week at time X.Entry D appears every day of the week but twice on each day at time X and y respectively.I'm trying to figure out how to set up a table(s) where an entry in the table can have 1 or more dates attached to it.So a single entry could have multiple dates and times attached to it.I hope this makes sense. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-17 : 11:49:56
|
tableA (id, entry)tableB (tableA_id, ApearingDate)One to many (A to B)
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Multiple Dates for 1 Table Entry