title: Update column with below query?
body: <p>How do I write this query to update a column based on the case statement?</p>
  
  <pre><code>UPDATE Table
  SET Form = CASE 
                WHEN (cnt - rownum &lt; cnt % NumberUp) 
                   THEN 0 
                   ELSE  floor((rowNum - 1) / numberUp) + 1 
             END AS form
  ORDER BY Quantity
  </code></pre>