Hi Allan,
What field(s) in the SecondTable table define which occurence is first and which is second?
>Hi,
>
>Im my appp, there is a stored proc that loops through one table and finds a matching entry in another table and updates both tables 'RecordMatchID' field with the same integer value.
>
>With this data, 99.9% of the time there is a one-to-one match - however, occasionally, the source table will have one record that "matches" to two records in the second table.
>
>Currently when I update the second table, I use something like this:
>
>Update SecondTable
>set SecondTable.RecordMatchID = @MatchIN
>where SecondTable.MatchCriteriaVC = @MatchVC
>
>What I'd like to do in the .01% of the cases where there are more than one matching record - is to just update 'SecondTable' for the first occurance where the matching criteria is met ...
>
>Any suggestions on how to best approach this?
--sb--