UPDATE Snipe SET AuctionEndDate = (SELECT ENDDATE FROM Ebay's webpage WHERE Ebay.ID = Snipe.EbayID) WHERE SnipeCreateDate >= Ebay.FormatChangeDate AND SnipeCreateDate <= AS.FormatChangeFixedDate
Suggestion: