﻿DECLARE IntezmenyCursor CURSOR FOR 
SELECT ID FROM T_INTEZMENY WHERE TOROLT = 'F' 

DECLARE @intezmenyId int

OPEN IntezmenyCursor
FETCH NEXT FROM IntezmenyCursor into @intezmenyId 
WHILE @@FETCH_STATUS = 0
BEGIN
  EXEC dev.uspGenerateTanevAdatokFromExistingTanev 
   @intezmenyId = @intezmenyId
  ,@tanevNeveNew = '2018/2019'
  ,@tanevNeveSource = '2017/2018'
  ,@kovetkezoTanev = 1
  FETCH NEXT FROM IntezmenyCursor into @intezmenyId 
END

CLOSE IntezmenyCursor
DEALLOCATE IntezmenyCursor
GO


