Hello I need your help to implement a trigger that will fire only when a column (Approved) is updated and it will run a different sets of code depending on the updated Value (0 or 1).
CREATE TRIGGER [dbo].[ApproveTimesheet] ON [dbo].[TIMESHEET_STATUS] AFTER UPDATEAS If (UPDATE(Approved))BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; If (Approved) = True THEN -- Update if approved UPDATE dbo.TIMESHEET_STATUS SET DateApproved = GetDate() where RecordId = RecordId AND Approved = 1 ... do more stuff here Else -- Update if disapproved UPDATE dbo.TIMESHEET_STATUS SET DateApproved = NULL where RecordId = RecordId AND Approved = 0 ... do more stuff here End IfEND