TR_MEMBERSHIPLEVEL_INSERTUPDATE_CURRENCY

                    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