﻿DISABLE TRIGGER ALL ON T_DICTIONARYITEMBASE
GO

UPDATE T_DICTIONARYITEMBASE
SET TOROLT = 'T'
WHERE ID IN (1295, 1232, 1234, 1229, 1211, 1216, 1199, 1214, 1215, 1227, 1231, 1233, 1262, 1282, 1289, 1290, 1292)

UPDATE T_TARGYKATEGORIATIPUS
SET TOROLT = 'T'
WHERE ID IN (1295, 1232, 1234, 1229, 1211, 1216, 1199, 1214, 1215, 1227, 1231, 1233, 1262, 1282, 1289, 1290, 1292)

UPDATE T_TANTARGY
SET C_TARGYKATEGORIA = 6708
WHERE C_TARGYKATEGORIA = 1295

UPDATE T_TANTARGY
SET C_TARGYKATEGORIA = 6755
WHERE C_TARGYKATEGORIA IN (1232, 1234)

UPDATE T_TANTARGY
SET C_TARGYKATEGORIA = 1230
WHERE C_TARGYKATEGORIA = 1229

UPDATE T_TANTARGY
SET C_TARGYKATEGORIA = 1293
WHERE C_TARGYKATEGORIA IN (1211, 1216)

UPDATE T_TANTARGY
SET C_TARGYKATEGORIA = 1197
WHERE C_TARGYKATEGORIA IN (1199, 1214, 1215, 1227, 1231, 1233, 1262, 1282, 1289, 1290, 1292)

GO

ENABLE TRIGGER ALL ON T_DICTIONARYITEMBASE
GO
