Files
2024-03-13 00:33:46 +01:00

6 lines
250 B
SQL

update T_ORARENDIORA
set
C_CSENGETESIRENDID = (select C_CSENGETESIRENDID from T_CSENGETESIRENDORA where ID = C_CSENGETESIRENDORAID),
LASTCHANGED = GETDATE()
where
C_CSENGETESIRENDORAID is not null and C_CSENGETESIRENDID is null and TOROLT = 'F'