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 ...