Versions Compared

Old Version 1

changes.mady.by.user Fabio Crescenzio

Saved on

compared with

New Version Current

changes.mady.by.user Fabio Crescenzio

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
UPDATE [:databaseGroup].dbo.Hotels SET ZuoraAccountId = :newZuoraAccountIdNULL, ZuoraCurrencyCode = :newCurrency WHERE hotelId = ':hotelId'

--In case you removed the previous account:
--UPDATE [v4].dbo.ContactInfos SET ZuoraContactId = NULL WHERE contactInfoId IN (SELECT contactInfoId FROM v4.dbo.contactInfosAffect WHERE obj_id = ':hotelId')

...