troubleshooting Question

create trigger to reset value every one year in sql server

Avatar of Sok Dymang
Sok DymangFlag for Cambodia asked on
Microsoft SQL Server.NET ProgrammingVisual Basic.NET
4 Comments1 Solution86 ViewsLast Modified:
Dear all brothers and sisters, i have a table "tbl_anualLeave" and default annual leave value for all user is 8, so when HR input amount of user take leave it will take that data to calculate with 8 and update the result to the table of that user,  no matter how user use all of their annual leave amount, the system will reset their current remain to 8 every (new year) - Jan -01, it mean that their annual leave will automatically reset to 8 every new year.  Thanks in advance
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros