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 |
|
lacrimasienna
Starting Member
2 Posts |
 Posted - 2011-05-22 : 03:20:28
|
I am creating a ToDo List in MS SQL Server 2008. I have made a table 'Task', and now I am interested in HOW TO MAKE MY TASKS TO REPEAT. Am I going to make a new table with name 'Period' with different time period for example: Every year, Every day..., and just make a relationship between these two tables, or there is some other way to do this??? How it is usually done? Consider I am a beginner in creating databases. Please help! Thanks! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-22 : 06:20:01
|
| Have a look at the system tables in msdb to do with scheduling. Just look in bol or google for sysschedules.You will also have to decide whether you just leave the entries to be viewed from the Period table or whether you add the tasks to the task table - maybe daily.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Task period in ToDoList