12 lines
397 B
Transact-SQL
12 lines
397 B
Transact-SQL
UPDATE T_ORARENDIORA SET C_ORAKEZDETE = CAST(CAST(C_ORAKEZDETE AS TIME) AS DATETIME)
|
|
WHERE C_ORAKEZDETE >= '19010102' AND C_TANORANKIVULIFOGLALKOZAS = 'T'
|
|
GO
|
|
|
|
UPDATE T_ORARENDIORA SET C_ORAVEGE = CAST(CAST(C_ORAVEGE AS TIME) AS DATETIME)
|
|
WHERE C_ORAVEGE >= '19010102' AND C_TANORANKIVULIFOGLALKOZAS = 'T'
|
|
GO
|
|
|
|
UPDATE T_ORARENDIORA SET C_ORASZAM = NULL
|
|
WHERE C_TANORANKIVULIFOGLALKOZAS = 'T'
|
|
GO
|