TR_CAMPAIGN_INSERT_BASECURRENCYID (Trigger)

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