Demo entry 2336735

#7879

   

Submitted by anonymous on Aug 04, 2015 at 09:26
Language: SQL. Code size: 347 Bytes.

INSERT INTO event_ref_office_notification(EventType, RefPhysicianOfficeId, CreatedBy, CreatedDate)
(SELECT DISTINCT 7, RefPhysicianOfficeId, 2, NOW()
  FROM ref_phy_office_contact oc
  WHERE DefaultContact is TRUE 
      AND NOT EXISTS(SELECT * FROM event_ref_office_notification eon WHERE eon.RefPhysicianOfficeId = oc.RefPhysicianOfficeId));

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).