Afternoon,
I want to perform an update to a record on the left hand side of my join, for the number of times the join condition is true. For exmaple:
However, the code above obviously only updates each record where the condition is true once.
I hope this makes sense. Any assistance is greatly appreciated.
TheGeezza
I want to perform an update to a record on the left hand side of my join, for the number of times the join condition is true. For exmaple:
Code:
update A
set match_counter = match_counter + 1
from TABLEA A
left join TABLEB B on
A.postcode = B.postcode
However, the code above obviously only updates each record where the condition is true once.
I hope this makes sense. Any assistance is greatly appreciated.
TheGeezza