title: An aggregate function not appear in the set list of an UPDATE statement
body: <pre><code>UPDATE PSO_UltraCoatRolls  
  SET TotalInSeries=
  COUNT(pd.PINSerialNumber) 
  FROM PINDetail pd 
  WHERE pd.PINSerialNumber 
  BETWEEN (SELECT pr.StratSerial FROM PSO_UltraCoatRolls pr) AND 
  (SELECT pr1.EndSerial FROM PSO_UltraCoatRolls pr1)
  </code></pre>