TR_PDCOMPOSITESEGMENTMAPPINGENTRY_IUD (Trigger)

                        
                create trigger [dbo].[TR_PDCOMPOSITESEGMENTMAPPINGENTRY_IUD] on [dbo].[PDCOMPOSITESEGMENTMAPPINGENTRY]
                after insert, update, delete not for replication
                    as 
                    begin
                        set nocount on
                        declare @MappingID uniqueidentifier
                        select top 1 @MappingID = PDCOMPOSITESEGMENTMAPPINGID from inserted 

                        update dbo.PDCOMPOSITESEGMENTMAPPING set COMPOSITESEGMENTKEY = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_KEY(@MappingID) where ID = @MappingID    
                    end