TR_DESIGNATION_INSERTUPDATE_CURRENCY (Trigger)

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