I know this has worked in the past. But running this now updates every record instead of just the requested date range. Any idea why?
SET Version = 8
FROM Person INNER JOIN
Company ON Person.CompanyId = Company.companyId INNER JOIN
License AS License_1 ON Person.PersonId = License_1.CustomerId
WHERE (Company.anniversary >= '7/1/2009'))
What's really weird is I can change the inequality and it still updates all records.
??? - thanks - dave
Very funny video -
What's your Metaphor?
View Complete Post