-- Migráció
DECLARE 
   @pLekerdezesDatuma nvarchar(12) = CONVERT(nvarchar, GETDATE(), 23)
DECLARE 
   @pGeneraltHonap int = NULL
  ,@pVisszaallitasDatuma datetime = NULL

DECLARE @tanevId nvarchar(100)
IF @pLekerdezesDatuma IS NOT NULL BEGIN
  DECLARE cur CURSOR LOCAL FOR
  SELECT ia.C_TANEVID
  FROM T_INTEZMENY i
	  INNER JOIN T_INTEZMENYADATOK ia ON i.ID = ia.C_INTEZMENYID AND ia.TOROLT = 'F'
	  INNER JOIN T_TANEV tv ON tv.ID = ia.C_TANEVID AND tv.TOROLT = 'F'
  WHERE i.TOROLT = 'F' AND ia.C_ISSZAKKEPZOJUTTATAS = 'T' AND tv.C_NEV = '2021/2022'
		
  OPEN cur
  FETCH NEXT FROM cur INTO @tanevId
  WHILE @@FETCH_STATUS = 0 BEGIN
	  EXEC uspUpdateTanuloSzakkepzesiJuttatasok
       @pTanevId = @tanevId
	    ,@pMaxIgazolatlanokSzama = 6
	    ,@pMinOsztondijAtlag = 2.0
	    ,@pOsztondijAlap = 167400
	    ,@pLekerdezesDatuma = @pLekerdezesDatuma
	    ,@pTanuloId = NULL
	    ,@pTanuloIdList = NULL
	    ,@pFelhasznaloId = 0
	    ,@pGeneraltHonap = @pGeneraltHonap
	    ,@pVisszaallitasDatuma = @pVisszaallitasDatuma
	  FETCH NEXT FROM cur INTO @tanevId
  END
  CLOSE cur
  DEALLOCATE cur
END
GO