title: An aggregate may not appear in the set list of an UPDATE statement
body: <pre><code>UPDATE [silverdb01].[dbo].[info] 
  SET [FM] = SUM(a.[MONDAY] - b.[QUOTA]) 
  FROM  [silverdb01].[dbo].[info] a,  [silverdb01].[dbo].[quota] b 
  WHERE a.[WORK_TYPE]='IN' AND a.[NAME]='KUTHAY'
  </code></pre>
  
  <p>When I run this I get the following error:</p>
  
  <blockquote>
    <p><em>An aggregate may not appear in the set list of an UPDATE statement.</em></p>
  </blockquote>
  
  <p>Any ideas?</p>