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 |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2001-07-05 : 10:56:06
|
| I'm a little stuck on the best way to do this. I've got an app with a SQL7 backend and Access forms on the front end that tracks some annual tests that employees must complete. Each employee is assigned to a quarter qroup meaning that their annual tests are due at the end of Q1, Q2, Q3 or Q4. What I'm trying to do is to calculate the default value on a column as the next due date. The quarter group value is stored in a different table.Is there a way to:1. Execute a sproc in a default to calculate this value using some sort of case statement?2. Another way to calculate this date by pulling the quarter group from another table?The user wants to be able to change the quarter group at will which then will default the due dates of the next tests as a year from the selected quarter.Any ideas to get me on track? |
|
|
|
|
|
default/contraint values