DECLARE @now DATETIME2 = getdate(); UPDATE T_Munkakortipus SET C_Alkalmazottmunkakortipusid = 8386 ,Serial = Serial + 1 ,Modifier = 0 ,Lastchanged = @Now WHERE Torolt = 'F' AND Id IN (6452, 8372); UPDATE T_Munkakortipus SET C_Alkalmazottmunkakortipusid = 8384 ,Serial = Serial + 1 ,Modifier = 0 ,Lastchanged = @Now WHERE Torolt = 'F' AND Id IN (8736, 8737, 8738, 8739, 8740);