This is something you would never want to do with these two tables in real life, but I wanted to try out the functionality so that tomorrow I could go up to work and try it on a temp table as part of a project we are currently working on.
I also want to try this with a
WHERE Sales.SalesPerson.BusinessEntityID = Sales.SalesPersonQuotaHistory.BusinessEntityID
instead of the “FROM” clause – though if this has a chance of working, I need to update the set line to:
SET Sales.SalesPerson.Bonus = Sales.SalesPersonQuotaHistory.Bonus
I guess we shall see. 🙂