TR_EVENT_UPDATE_ENDDATETIMEWITHOFFSET

                    CREATE trigger TR_EVENT_UPDATE_ENDDATETIMEWITHOFFSET on dbo.EVENT after insert,update not for replication
                    as begin
                        set nocount on;

                        if update(ENDDATE) or update(ENDTIME)
                            begin
                                update dbo.EVENT set ENDDATETIMEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(inserted.ENDDATETIME, 0),
                                    CHANGEDBYID = inserted.CHANGEDBYID,
                                    DATECHANGED = getdate()
                                from dbo.EVENT E inner join inserted on E.ID = inserted.ID
                            end

                    end