title: Update specific rows in sql table
body: <p>I have the following SELECT statement.</p>
  
  <pre><code>SELECT     AETID, DSRID, FYEID, BASICRATE, EURORATE, 
    COMID, BRAID, CURID, CURIDCONV, ENTRYDATE, EVNUMBER, 
    ORIGIN, IEEID, RELDOCNUM, GJOID, JOURNALNUM,
    JUSTIFICATION, KEPYOAMOUNT, KEPYONUM, STATUS, 
    UPDSTATUS, TOTALCB, IDLINKED, CREUSERID, CREUSERDATE, 
    UPDUSERID, UPDUSERDATE, ACEIDCROSSENTRY, ACEIDCROSSEDENTRY, 
    ISCROSS, ISCROSSED, ACEIDCANCEL, ACEIDPRIMARY, CCEID
  FROM         EliteUser.ACE
  WHERE     (JOURNALNUM &gt; 1193) 
    AND (JOURNALNUM &lt; 2387)
  </code></pre>
  
  <p>What I want to do is update the specific rows so that where <code>journalnum = 1194</code> updates to 1, where <code>journalnum = 1195</code> updates to 2, etc</p>