title: How do I update multiple columns with a subquery in a single statement?
body: <p>I am attempting to update a temp table from a source table:</p>
  
  <pre><code>    UPDATE #DETAIL
          SET EXCD_ID, CDOR_OR_AMT, CDOR_OR_VALUE
          (SELECT 
              CDID_ADDL_DATA_1, CDID_ADDL_DATA, CDID_VALUE_STRING
          FROM
              CMC_CDID_DATA CDID
          WHERE
              CDID.CLCL_ID = DTL.CLCL_ID AND
              CDID.CDML_SEQ_NO = DTL.CDML_SEQ_NO AND
              CDID_TYPE = 'NDC'
      )
      FROM #DETAIL DTL
      WHERE DTL.CDOR_OR_ID = 'XS'
  </code></pre>
  
  <p>Unfortunately it complains</p>
  
  <pre><code>Incorrect syntax near ',' (on the '(SELECT' line)
  Incorrect syntax near 'FROM' (the second one)
  </code></pre>