Prevent Trigger from firerig
===

i have two Trigger.

First Trigger:

    ALTER TRIGGER [dbo].[DIENSTLEISTUNG_Update]
    ON [dbo].[DIENSTLEISTUNG]
    INSTEAD OF UPDATE
    AS
    
    BEGIN
    	SET  NOCOUNT ON;
        DECLARE @intNewID int
    
             INSERT INTO [DIENSTLEISTUNG] 
             (DESCRIPTION, QUANTITY, 
             PRICE, AZ_MO, AZ_DI,AZ_MI,AZ_DO,AZ_FR,
             AZ_SA,AZ_SO,DIENSTLEISTUNGSART_ID,
             UPDATE_USER, UPDATE_DATE,
             PERMISSIONS, KONTRAKTPOSITION,ITEMNUMBER,
             PRIORITY, VALID)
             
             SELECT  i.DESCRIPTION, i.QUANTITY, i.PRICE, i.AZ_MO, 
             i.AZ_DI,i.AZ_MI,i.AZ_DO,i.AZ_FR,       
             i.AZ_SA,i.AZ_SO,i.SERVICETYPE_ID, i.UPDATE_USER,GETDATE(),
             i.PERMISSIONS, i.KONTRAKTPOSITION,i.ITEMNUMBER, i.PRIORITY, 'Y'
            
             FROM INSERTED i
             JOIN deleted d ON i.ID=d.ID
             WHERE i.PRICE<>d.PRICE
             or i.DESCRIPTION<>d.DESCRIPTION
    
             UPDATE  S
             SET  s.VALID = 'N'    
             FROM SERVICE s
             JOIN INSERTED i ON I.ID = S.ID
          	    	
       SET NOCOUNT OFF;      
    END

Second Trigger:

    ALTER TRIGGER [dbo].[DIENSTLEISTUNG2_Update]
    ON [dbo].[DIENSTLEISTUNG]
    FOR UPDATE
    AS

        BEGIN
            UPDATE s
    	    SET s.PRIORITY= i.PRIORITY
    		FROM SERVICE s
    		JOIN INSERTED i ON i.ID = s.ID
    		JOIN DELETED d ON i.ID = d.ID
    		WHERE d.PRIORITY= i.PRIORITY
        END


The First Trigger copies an entire row with a new ID if a change in the original row happens, also the Trigger set a FLag. The old row gets the Flag VALID = 'N' and the new row gets the Flag VALID = 'Y' . The Trigger only creates a new row if PRICE or DESCRIPTION is updated. So far so good. My Problem is that if i want to Update the PRIORITY in the new row the Trigger fires again and set the Flag to VALID = 'N'. That should not happen. I want only to Update the Priority without creating a new row or update a another column.

For that i have written the second Trigger. But i have the same Problem. If i Update Priority the First Trigger is fired again and set the FLAG to VALID = 'N'.


How can i Prevent that my first Trigger is firering if i Update Priority or how can i put that in one Trigger.


Thanks for help