...
Code Block | ||
---|---|---|
| ||
UPDATE [:databaseGroup].dbo.Hotels SET ZuoraAccountId = NULL, ZuoraInvoiceTemplateId = NULL, ZuoraTenantId = :newTenantId WHERE hotelId = ':hotelId'
UPDATE [v4].dbo.ContactInfos SET ZuoraContactId = NULL WHERE contactInfoId IN (SELECT contactInfoId FROM v4.dbo.contactInfosAffect WHERE obj_id = ':hotelId') |
...