﻿--Migration
UPDATE ic
  SET
     C_ERTEK = 'true'
    ,SERIAL = SERIAL + 1
    ,LASTCHANGED = GETDATE()
    ,MODIFIER = 0
--select *
FROM T_INTEZMENYCONFIG ic
WHERE ic.C_CONFIGTIPUSID = 14
  AND EXISTS (SELECT 1 FROM dev.EnvironmentInfo ei WHERE ei.[Key] = 'Kornyezet' and ei.[Value] = 'NSZFH')
  AND ic.C_ERTEK <> 'true'
