Change Enable Option for Days (Requires Edit)

01/11/2024 9:37 am EST

This query requires editing of information before being executed.

UPDATE AccountContacts
SET EnableMonday = 0
WHERE AccountID in (SELECT ID FROM AccountMain WHERE GroupID = 569) and BeginDate = '2017-09-05 00:00:00'

UPDATE AccountContacts
SET EnableTuesday = 0
WHERE AccountID in (SELECT ID FROM AccountMain WHERE GroupID = 569) and BeginDate = '2017-09-05 00:00:00'

UPDATE AccountContacts
SET EnableWednesday = 0
WHERE AccountID in (SELECT ID FROM AccountMain WHERE GroupID = 569) and BeginDate = '2017-09-05 00:00:00'

UPDATE AccountContacts
SET EnableThursday = 0
WHERE AccountID in (SELECT ID FROM AccountMain WHERE GroupID = 569) and BeginDate = '2017-09-05 00:00:00'

UPDATE AccountContacts
SET EnableFriday = 0
WHERE AccountID in (SELECT ID FROM AccountMain WHERE GroupID = 569) and BeginDate = '2017-09-05 00:00:00'

Was this article helpful?