kreta/Kreta.DataAccess.Migrations/Scripts/20210317141324_KRETA2_5853/KRETA2_5853.sql
2024-03-13 00:33:46 +01:00

6 lines
No EOL
208 B
SQL

UPDATE DIT SET
DIT.C_NAME = 'Záradékok'
FROM T_DICTIONARYTYPE DIT
INNER JOIN T_TANEV t ON t.ID = DIT.C_TANEVID AND t.C_SORSZAM >38
WHERE DIT.C_CODENAME = 'SorolasOkaTipus'
AND DIT.TOROLT = 'F'