﻿--Migration
UPDATE onf 
SET C_ESLKOZEPESATLAG = 2.5 
FROM T_OKTATASINEVELESIFELADAT onf
  INNER JOIN T_TANEV tv ON tv.ID = onf.C_ALTANEVID AND tv.TOROLT = 'F'
  INNER JOIN T_INTEZMENY i ON i.ID = onf.C_ALINTEZMENYID AND i.TOROLT = 'F'
WHERE onf.ID IN (1160, 1161, 1162, 5435, 1176, 6463, 7664, 7760, 7764, 7765, 7766, 7894, 7895, 7896) 

