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 |
|
biffysix
Starting Member
5 Posts |
 Posted - 2002-07-02 : 04:04:52
|
| Is it possible for a person's holiday to be added a day when a certain period has passed from the start date automatically with sql server (according to the sql server time) or must update with an select update statement. ie click update to find out if a person has accumulated a holiday.Thanks |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-07-02 : 04:45:09
|
| Yes, anything is possible. It's usually the degree of difficulty that determines the implementation.Some options for getting a persons holiday balance:- UDF(SQL 2000)/Stored proc to calculate it with a select statement on request.- scheduled job that updates the value in a table on a daily/monthly basis. |
 |
|
|
|
|
|
Update Holidays accrued from Start date