Hi,
I am looking for a help to get the following functionality
I have two table
1. Attendance table with column employee, logdate, Workinghours, HolidayHours
2. Holiday table with column employee, DateHoliday,HolidayHours
I want to call a trigger on Attendance table if there is insert, delete or update. If the HolidayHours in Attendance table have been updated with a value greater than 0 or inserted a new record in attendance table with
value greater than 0 in HolidayHours column or delete the record from Attendance having value in column HolidayHours as greater than 0 , to call a trigger to make consequent effect on Holiday Table.
If Insert the record in DailyAttendance table with HolidayHrs >0 Then new record must be inserted on Holiday table
If Update the record in DailyAttendance table with HoliadyHrs > 0 Then must be updated in Holida ...
Go to the complete details ...