>I'm working on my first update trigger.
>
>An SP that operates on the column I'm monitoring for update includes this fragment
>
>

>UPDATE dbo.PATIENT_CLAIM_837_2000C
>SET Claim_Status = '00'
>WHERE Claim_Seq_No = @iClaimSeqNo 
>      AND @iClaimPayersCount = @iMatchedPayersCount
>
>

>
>Is there any reason THAT form is preferable to:
>

>IF @iClaimPayersCount = @iMatchedPayersCount
>    UPDATE dbo.PATIENT_CLAIM_837_2000C
>    SET Claim_Status = '00'
>    WHERE Claim_Seq_No = @iClaimSeqNo 
>      
>

>
>The second form seems more efficient, and it does not fire the trigger if
>

@iClaimPayersCount <> @iMatchedPayersCount

>

Yes, second variation is indeed preferrable.