TR_EVENTSALESMETHOD_UPDATE_ONSALEDATETIMEWITHOFFSET

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

                        if update(ONSALEDATE) or update(ONSALETIME)
                            begin
                                update dbo.EVENTSALESMETHOD set ONSALEDATETIMEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(inserted.ONSALEDATETIME, 0),
                                        CHANGEDBYID = inserted.CHANGEDBYID,
                                        DATECHANGED = getdate()
                                    from dbo.EVENTSALESMETHOD ESM inner join inserted on ESM.ID = inserted.ID                        
                            end

                    end