title: Using Distinct in SQL Update
body: <p>Here is the Select I need to convert to an Update:</p>
  
  <pre><code>SELECT DISTINCT f.SectionID, f.Name, v.Enabled
  FROM SETTING_VALUE v
  INNER JOIN SETTING s ON v.SettingID = s.SettingID
  INNER JOIN LU_FIELD f ON f.FieldID = s.FieldID
  WHERE v.DisplayValue LIKE '%Miami%'
  AND f.ControlName LIKE '%City%'
  </code></pre>
  
  <p>My attempt:</p>
  
  <pre><code>UPDATE SETTING_VALUE
  SET Enabled = 0
  FROM SETTING_VALUE v
  INNER JOIN SETTING s ON v.SettingID = s.SettingID
  INNER JOIN LU_FIELD f ON f.FieldID = s.FieldID
  WHERE v.DisplayValue LIKE '%Miami%'
  AND f.ControlName LIKE '%City%'
  </code></pre>
  
  <p>Not sure how to apply Distinct</p>