Proc sql updating multiple columns
I don't think i can use the merge statement here since there are more than 1 condition that has to be met for the target table to be updated.
The way i understand it external tables don't have primary keys.
I cannot tell you how to make something more efficient if I do not know what is impeding the efficiency in the first place. Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant.