11 lines
354 B
Transact-SQL
11 lines
354 B
Transact-SQL
DISABLE TRIGGER ALL ON T_ORARENDIORA
|
|
GO
|
|
|
|
UPDATE oo
|
|
SET
|
|
C_ORAKEZDETE = ISNULL(csro.C_KEZDETE, '20000101 00:00:00')
|
|
,C_ORAVEGE = ISNULL(csro.C_VEGE, '20000101 00:00:00')
|
|
FROM T_ORARENDIORA oo
|
|
LEFT JOIN T_CSENGETESIRENDORA csro ON
|
|
csro.ID = oo.C_CSENGETESIRENDORAID AND csro.C_INTEZMENYID = oo.C_INTEZMENYID AND csro.C_TANEVID = oo.C_TANEVID
|