title: Updating DISTINCTROW in SQL Server
body: <p>This was originally an Access query updating DISTINCTROW. I cannot seem to find an equivalent way to do this in SQL Server. Is it even possible? As it is written in SQL Server:</p>
  
  <pre><code>UPDATE CustOrder
  SET  CustOrder.YARDS = QUANTITY * Lkp_Codes.VOLUME_GALS * 0.00495113
  FROM CustOrder 
  INNER JOIN Lkp_ServiceCodes as Lkp_Codes
  ON CustOrder.SERVICE_CODE = Lkp_Codes.[SVC CODE]
  </code></pre>