Hey guys,

Thanks a lot for the help!

Here is the final outcome:

IF UPDATE(VendorCode)

BEGIN

  UPDATE vendor...