TR_EVENT_INSERT_BASECURRENCYID (Trigger)

                
                    CREATE trigger [dbo].[TR_EVENT_INSERT_BASECURRENCYID] on [dbo].[EVENT] 
                    after insert
                    not for replication
                    as
                    begin
                        set nocount on;
                        
                        update dbo.EVENT set 
                            EVENT.BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            EVENT.CHANGEDBYID = EVENT.CHANGEDBYID,
                            EVENT.DATECHANGED = EVENT.DATECHANGED
                        from 
                            inserted
                            inner join dbo.EVENT on inserted.ID = EVENT.ID
                        where
                            inserted.BASECURRENCYID is null;
                    end