TR_MEMBERSHIPLEVEL_INSERTUPDATE_CURRENCY (Trigger)

                
                    create trigger [dbo].[TR_MEMBERSHIPLEVEL_INSERTUPDATE_CURRENCY] on [dbo].[MEMBERSHIPLEVEL]
                        after insert
                        not for replication
                        as
                        begin
                            set nocount on;
                            
                            declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(); 
                        
                            update
                                dbo.MEMBERSHIPLEVEL
                            set
                                MEMBERSHIPLEVEL.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
                                MEMBERSHIPLEVEL.CHANGEDBYID = MEMBERSHIPLEVEL.CHANGEDBYID,
                                MEMBERSHIPLEVEL.DATECHANGED = MEMBERSHIPLEVEL.DATECHANGED
                            from
                                inserted
                            inner join
                                dbo.MEMBERSHIPLEVEL on inserted.ID = MEMBERSHIPLEVEL.ID
                            where
                                MEMBERSHIPLEVEL.BASECURRENCYID is null;
                        end