Facebook
From stefaan, 1 Month ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 129
  1. update op
  2. set op.datetime_planned = oa.DateTime_Start
  3. from Ris.dbo.tblOrder_Appointment oa
  4. inner join Ris.dbo.tblOrder_Procedure op on op.Order_UID = oa.Order_UID
  5. inner join Ris.dbo.tblorder o on o.id = op.Order_UID
  6. where YEAR(DateTime_Start) >= '2024'
  7. and DateTime_Start >= '2024-02-01 00:00:00.000'
  8. and op.DateTime_Planned is NULL
  9. and op.Removed = '0'
  10. and o.Deleted = '0'
  11. and oa.deleted = '0'