﻿--Migration
update z
set TOROLT = 'T', MODIFIER = 0, LASTCHANGED = GETDATE(), SERIAL += 1
from T_ZARADEK z
inner join T_TANULOCSOPORT tcs on tcs.ID = z.C_TANULOCSOPORTID
where tcs.C_TANEVID <> z.C_TANEVID