DECLARE @ILKTARIH NVARCHAR(11),@SONTARIH NVARCHAR(11)
SET @ILKTARIH = '01.01.2006'
SET @SONTARIH = '31.12.2020'
DECLARE @SONNUMARA INT
SET @SONNUMARA = ISNULL((SELECT MAX(JOURNALNO) FROM LG_100_01_EMFICHE WHERE DATE_<CONVERT(DATETIME,@ILKTARIH,104)),0)+1
DECLARE @LOGICALREF INT
DECLARE YEVMIYENO CURSOR FOR
SELECT LOGICALREF FROM LG_100_01_EMFICHE
WHERE DATE_ BETWEEN CONVERT(DATETIME,@ILKTARIH,104) AND CONVERT(DATETIME,@SONTARIH,104)
ORDER BY DATE_
OPEN YEVMIYENO
FETCH NEXT FROM YEVMIYENO INTO @LOGICALREF
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE LG_100_01_EMFICHE SET GENEXP4=JOURNALNO,JOURNALNO = @SONNUMARA WHERE LOGICALREF=@LOGICALREF
SET @SONNUMARA = @SONNUMARA + 1
FETCH NEXT FROM YEVMIYENO INTO @LOGICALREF
END
CLOSE YEVMIYENO
DEALLOCATE YEVMIYENO
Yorumlar
Yorum Gönder