title: SQL Update Query Error
body: <p>This worked before but now it isn't working and I'm very confused. I reviewed the whole thing and it all looks fine but maybe somebody more advanced can spot something?</p>
  
  <p>Here's the script:</p>
  
  <pre><code>UPDATE Orders SET Orders.OrderStatus = 'Shipped',Orders.SalesRep_CustomerID = null
  WHERE Orders.OrderStatus in ('Pending','Processing') 
  AND Orders.PaymentAmount = Orders.Total_Payment_Received
  AND Orders.ShipDate &lt; dateadd(day, -60, convert(char(10), getdate(), 101))
  AND Orders.Shipped = Y
  </code></pre>
  
  <p>All I'm getting is an Error, no explanation. Can somebody spot an error, I'm sure it's obvious I'm just too new to SQL to identify it. Thanks</p>