yedek aldıktan sonra şu quary çalıştıralım ;
DECLARE
@SQLSTR nvarchar(4000),
@RECNUM int,
@NEWLREF int,
@LREF int ,
@PERREF int ,
@JOBLNNR smallint ,
@BEGDATE datetime ,
@ENDDATE datetime ,
@PERCODE varchar (17) ,
@FIRMNR smallint ,
@LOCNR smallint ,
@TYP smallint ,
@ACTIVE smallint ,
@OUTREASON smallint ,
@OUTOPDATE datetime ,
@BUFF int ,
@INOK smallint ,
@OUTOK smallint ,
@REPSTATS1 smallint ,
@REPSTATS2 smallint ,
@REPSTATS3 smallint ,
@REPSTATS4 smallint ,
@REPSTATS5 smallint ,
@REPSTATS6 smallint ,
@REPSTATS7 smallint ,
@REPSTATS8 smallint ,
@REPSTATS9 smallint ,
@REPSTATS10 smallint ,
@REPSTATS11 smallint ,
@REPSTATS12 smallint ,
@REPSTATS13 smallint ,
@REPSTATS14 smallint ,
@REPSTATS15 smallint ,
@REPSTATS16 smallint ,
@SSKSTATUS smallint ,
@SSKNO varchar (21) ,
@TTFNO varchar (21) ,
@FLAGS1 smallint ,
@FLAGS2 smallint ,
@FLAGS3 smallint ,
@FLAGS4 smallint ,
@FLAGS5 smallint ,
@FLAGS6 smallint ,
@FLAGS7 smallint ,
@FLAGS8 smallint ,
@EXP varchar (81) ,
@INJUREDEGREE smallint ,
@OUTRIGHTS1 smallint ,
@OUTRIGHTS2 smallint ,
@OUTRIGHTS3 smallint ,
@OUTRIGHTS4 smallint ,
@OUTRIGHTS5 smallint ,
@OUTRIGHTS6 smallint ,
@OUTRIGHTS7 smallint ,
@OUTRIGHTS8 smallint ,
@OUTRIGHTS9 smallint ,
@OUTRIGHTS10 smallint ,
@OUTRIGHTS11 smallint ,
@OUTRIGHTS12 smallint ,
@OUTRIGHTS13 smallint ,
@OUTRIGHTS14 smallint ,
@OUTRIGHTS15 smallint ,
@OUTRIGHTS16 smallint ,
@OUTCOEF1 float ,
@OUTCOEF2 float ,
@OUTCOEF3 float ,
@OUTCOEF4 float ,
@OUTCOEF5 float ,
@OUTCOEF6 float ,
@OUTCOEF7 float ,
@OUTCOEF8 float ,
@OUTAMNT1 float ,
@OUTAMNT2 float ,
@OUTAMNT3 float ,
@OUTAMNT4 float ,
@OUTAMNT5 float ,
@OUTAMNT6 float ,
@OUTAMNT7 float ,
@OUTAMNT8 float ,
@FREEWGDAY int ,
@CALCDATE datetime ,
@LEGISLATIVE smallint ,
@FROMOUT smallint ,
@CALCDT datetime ,
@ADDAID float ,
@CAPIBLOCK_CREATEDBY smallint ,
@CAPIBLOCK_CREATEDDT datetime ,
@CAPIBLOCK_CREATEDH smallint ,
@CAPIBLOCK_CREATEDM smallint ,
@CAPIBLOCK_CREATEDS smallint ,
@CAPIBLOCK_MODIFIEDBY smallint ,
@CAPIBLOCK_MODIFIEDDT datetime ,
@CAPIBLOCK_MODIFIEDH smallint ,
@CAPIBLOCK_MODIFIEDM smallint ,
@CAPIBLOCK_MODIFIEDS smallint ,
@SITEID smallint ,
@RECSTATUS smallint ,
@ORGLOGICREF int ,
@INDEMPAY smallint ,
@SSKDISCLAW smallint ,
@SSKDOCTYPE smallint ,
@SSKDEPLAW smallint ,
@FISERVADDRATIO smallint
PRINT 'Kaytlar gncelleniyor.'
DECLARE lch CURSOR FOR
SELECT LREF ,PERREF ,JOBLNNR ,BEGDATE ,ENDDATE ,PERCODE ,FIRMNR ,LOCNR ,TYP ,ACTIVE ,OUTREASON ,OUTOPDATE ,BUFF ,INOK ,OUTOK ,REPSTATS1 ,REPSTATS2 ,REPSTATS3 ,REPSTATS4 ,REPSTATS5 ,REPSTATS6 ,REPSTATS7 ,REPSTATS8 ,REPSTATS9 ,REPSTATS10 ,REPSTATS11 ,REPSTATS12 ,REPSTATS13 ,REPSTATS14 ,REPSTATS15 ,REPSTATS16 ,SSKSTATUS ,SSKNO ,TTFNO ,FLAGS1 ,FLAGS2 ,FLAGS3 ,FLAGS4 ,FLAGS5 ,FLAGS6 ,FLAGS7 ,FLAGS8 ,EXP ,INJUREDEGREE ,OUTRIGHTS1 ,OUTRIGHTS2 ,OUTRIGHTS3 ,OUTRIGHTS4 ,OUTRIGHTS5 ,OUTRIGHTS6 ,OUTRIGHTS7 ,OUTRIGHTS8 ,OUTRIGHTS9 ,OUTRIGHTS10 ,OUTRIGHTS11 ,OUTRIGHTS12 ,OUTRIGHTS13 ,OUTRIGHTS14 ,OUTRIGHTS15 ,OUTRIGHTS16 ,OUTCOEF1 ,OUTCOEF2 ,OUTCOEF3 ,OUTCOEF4 ,OUTCOEF5 ,OUTCOEF6 ,OUTCOEF7 ,OUTCOEF8 ,OUTAMNT1 ,OUTAMNT2 ,OUTAMNT3 ,OUTAMNT4 ,OUTAMNT5 ,OUTAMNT6 ,OUTAMNT7 ,OUTAMNT8 ,FREEWGDAY ,CALCDATE ,LEGISLATIVE ,FROMOUT ,CALCDT ,ADDAID ,CAPIBLOCK_CREATEDBY ,CAPIBLOCK_CREATEDDT ,CAPIBLOCK_CREATEDH ,CAPIBLOCK_CREATEDM ,CAPIBLOCK_CREATEDS ,CAPIBLOCK_MODIFIEDBY ,CAPIBLOCK_MODIFIEDDT ,CAPIBLOCK_MODIFIEDH ,CAPIBLOCK_MODIFIEDM ,CAPIBLOCK_MODIFIEDS ,SITEID ,RECSTATUS ,ORGLOGICREF ,INDEMPAY ,SSKDISCLAW ,SSKDOCTYPE ,SSKDEPLAW ,FISERVADDRATIO
FROM LH_001_LAWCHG LC
WHERE (LC.PERREF NOT IN (SELECT PERREF FROM LH_001_LAWCHG L1 WHERE L1.BEGDATE > = CONVERT(DATETIME,'2008-10-01',101)))
AND (LC.SSKDEPLAW = 0)
AND (LC.ENDDATE IS NULL)
OPEN lch
SET @RECNUM = 0
FETCH NEXT FROM lch
INTO @LREF ,
@PERREF ,
@JOBLNNR ,
@BEGDATE ,
@ENDDATE ,
@PERCODE ,
@FIRMNR ,
@LOCNR ,
@TYP ,
@ACTIVE ,
@OUTREASON ,
@OUTOPDATE ,
@BUFF ,
@INOK ,
@OUTOK ,
@REPSTATS1 ,
@REPSTATS2 ,
@REPSTATS3 ,
@REPSTATS4 ,
@REPSTATS5 ,
@REPSTATS6 ,
@REPSTATS7 ,
@REPSTATS8 ,
@REPSTATS9 ,
@REPSTATS10 ,
@REPSTATS11 ,
@REPSTATS12 ,
@REPSTATS13 ,
@REPSTATS14 ,
@REPSTATS15 ,
@REPSTATS16 ,
@SSKSTATUS ,
@SSKNO ,
@TTFNO ,
@FLAGS1 ,
@FLAGS2 ,
@FLAGS3 ,
@FLAGS4 ,
@FLAGS5 ,
@FLAGS6 ,
@FLAGS7 ,
@FLAGS8 ,
@EXP ,
@INJUREDEGREE ,
@OUTRIGHTS1 ,
@OUTRIGHTS2 ,
@OUTRIGHTS3 ,
@OUTRIGHTS4 ,
@OUTRIGHTS5 ,
@OUTRIGHTS6 ,
@OUTRIGHTS7 ,
@OUTRIGHTS8 ,
@OUTRIGHTS9 ,
@OUTRIGHTS10 ,
@OUTRIGHTS11 ,
@OUTRIGHTS12 ,
@OUTRIGHTS13 ,
@OUTRIGHTS14 ,
@OUTRIGHTS15 ,
@OUTRIGHTS16 ,
@OUTCOEF1 ,
@OUTCOEF2 ,
@OUTCOEF3 ,
@OUTCOEF4 ,
@OUTCOEF5 ,
@OUTCOEF6 ,
@OUTCOEF7 ,
@OUTCOEF8 ,
@OUTAMNT1 ,
@OUTAMNT2 ,
@OUTAMNT3 ,
@OUTAMNT4 ,
@OUTAMNT5 ,
@OUTAMNT6 ,
@OUTAMNT7 ,
@OUTAMNT8 ,
@FREEWGDAY ,
@CALCDATE ,
@LEGISLATIVE ,
@FROMOUT ,
@CALCDT ,
@ADDAID ,
@CAPIBLOCK_CREATEDBY ,
@CAPIBLOCK_CREATEDDT ,
@CAPIBLOCK_CREATEDH ,
@CAPIBLOCK_CREATEDM ,
@CAPIBLOCK_CREATEDS ,
@CAPIBLOCK_MODIFIEDBY ,
@CAPIBLOCK_MODIFIEDDT ,
@CAPIBLOCK_MODIFIEDH ,
@CAPIBLOCK_MODIFIEDM ,
@CAPIBLOCK_MODIFIEDS ,
@SITEID ,
@RECSTATUS ,
@ORGLOGICREF ,
@INDEMPAY ,
@SSKDISCLAW ,
@SSKDOCTYPE ,
@SSKDEPLAW ,
@FISERVADDRATIO
WHILE @@FETCH_STATUS = 0
BEGIN
SET @RECNUM = @RECNUM + 1
yasak LH_001_LAWCHG SET ENDDATE = CONVERT(DATETIME,'2008-09-30',101) WHERE LREF = @LREF
SELECT @NEWLREF = MAX(LASTLREF)+1 FROM LH_001_LAWCHGSEQ
SET @SSKDEPLAW = 1
SET @BEGDATE = CONVERT(DATETIME,'2008-10-01')
SET @ENDDATE = NULL
SET @CAPIBLOCK_CREATEDDT = getdate()
SET @CAPIBLOCK_CREATEDH = 0
SET @CAPIBLOCK_CREATEDM = 0
SET @CAPIBLOCK_CREATEDS = 0
SET @CAPIBLOCK_MODIFIEDBY = NULL
SET @CAPIBLOCK_MODIFIEDDT = NULL
SET @CAPIBLOCK_MODIFIEDH = NULL
SET @CAPIBLOCK_MODIFIEDM = NULL
SET @CAPIBLOCK_MODIFIEDS = NULL
SET @EXP = 'Tabi oldugu yasa değişikliği'
SET @CAPIBLOCK_CREATEDBY = 1
INSERT INTO LH_001_LAWCHG (LREF ,PERREF ,JOBLNNR ,BEGDATE ,ENDDATE ,PERCODE ,FIRMNR ,LOCNR ,TYP ,ACTIVE ,OUTREASON ,OUTOPDATE ,BUFF ,INOK ,OUTOK ,REPSTATS1 ,REPSTATS2 ,REPSTATS3 ,REPSTATS4 ,REPSTATS5 ,REPSTATS6 ,REPSTATS7 ,REPSTATS8 ,REPSTATS9 ,REPSTATS10 ,REPSTATS11 ,REPSTATS12 ,REPSTATS13 ,REPSTATS14 ,REPSTATS15 ,REPSTATS16 ,SSKSTATUS ,SSKNO ,TTFNO ,FLAGS1 ,FLAGS2 ,FLAGS3 ,FLAGS4 ,FLAGS5 ,FLAGS6 ,FLAGS7 ,FLAGS8 ,EXP ,INJUREDEGREE ,OUTRIGHTS1 ,OUTRIGHTS2 ,OUTRIGHTS3 ,OUTRIGHTS4 ,OUTRIGHTS5 ,OUTRIGHTS6 ,OUTRIGHTS7 ,OUTRIGHTS8 ,OUTRIGHTS9 ,OUTRIGHTS10 ,OUTRIGHTS11 ,OUTRIGHTS12 ,OUTRIGHTS13 ,OUTRIGHTS14 ,OUTRIGHTS15 ,OUTRIGHTS16 ,OUTCOEF1 ,OUTCOEF2 ,OUTCOEF3 ,OUTCOEF4 ,OUTCOEF5 ,OUTCOEF6 ,OUTCOEF7 ,OUTCOEF8 ,OUTAMNT1 ,OUTAMNT2 ,OUTAMNT3 ,OUTAMNT4 ,OUTAMNT5 ,OUTAMNT6 ,OUTAMNT7 ,OUTAMNT8 ,FREEWGDAY ,CALCDATE ,LEGISLATIVE ,FROMOUT ,CALCDT ,ADDAID ,CAPIBLOCK_CREATEDBY ,CAPIBLOCK_CREATEDDT ,CAPIBLOCK_CREATEDH ,CAPIBLOCK_CREATEDM ,CAPIBLOCK_CREATEDS ,CAPIBLOCK_MODIFIEDBY ,CAPIBLOCK_MODIFIEDDT ,CAPIBLOCK_MODIFIEDH ,CAPIBLOCK_MODIFIEDM ,CAPIBLOCK_MODIFIEDS ,SITEID ,RECSTATUS ,ORGLOGICREF ,INDEMPAY ,SSKDISCLAW ,SSKDOCTYPE ,SSKDEPLAW ,FISERVADDRATIO) VALUES (
@NEWLREF ,
@PERREF ,
@JOBLNNR ,
@BEGDATE ,
@ENDDATE ,
@PERCODE ,
@FIRMNR ,
@LOCNR ,
@TYP ,
@ACTIVE ,
@OUTREASON ,
@OUTOPDATE ,
@BUFF ,
@INOK ,
@OUTOK ,
@REPSTATS1 ,
@REPSTATS2 ,
@REPSTATS3 ,
@REPSTATS4 ,
@REPSTATS5 ,
@REPSTATS6 ,
@REPSTATS7 ,
@REPSTATS8 ,
@REPSTATS9 ,
@REPSTATS10 ,
@REPSTATS11 ,
@REPSTATS12 ,
@REPSTATS13 ,
@REPSTATS14 ,
@REPSTATS15 ,
@REPSTATS16 ,
@SSKSTATUS ,
@SSKNO ,
@TTFNO ,
@FLAGS1 ,
@FLAGS2 ,
@FLAGS3 ,
@FLAGS4 ,
@FLAGS5 ,
@FLAGS6 ,
@FLAGS7 ,
@FLAGS8 ,
@EXP ,
@INJUREDEGREE ,
@OUTRIGHTS1 ,
@OUTRIGHTS2 ,
@OUTRIGHTS3 ,
@OUTRIGHTS4 ,
@OUTRIGHTS5 ,
@OUTRIGHTS6 ,
@OUTRIGHTS7 ,
@OUTRIGHTS8 ,
@OUTRIGHTS9 ,
@OUTRIGHTS10 ,
@OUTRIGHTS11 ,
@OUTRIGHTS12 ,
@OUTRIGHTS13 ,
@OUTRIGHTS14 ,
@OUTRIGHTS15 ,
@OUTRIGHTS16 ,
@OUTCOEF1 ,
@OUTCOEF2 ,
@OUTCOEF3 ,
@OUTCOEF4 ,
@OUTCOEF5 ,
@OUTCOEF6 ,
@OUTCOEF7 ,
@OUTCOEF8 ,
@OUTAMNT1 ,
@OUTAMNT2 ,
@OUTAMNT3 ,
@OUTAMNT4 ,
@OUTAMNT5 ,
@OUTAMNT6 ,
@OUTAMNT7 ,
@OUTAMNT8 ,
@FREEWGDAY ,
@CALCDATE ,
@LEGISLATIVE ,
@FROMOUT ,
@CALCDT ,
@ADDAID ,
@CAPIBLOCK_CREATEDBY ,
@CAPIBLOCK_CREATEDDT ,
@CAPIBLOCK_CREATEDH ,
@CAPIBLOCK_CREATEDM ,
@CAPIBLOCK_CREATEDS ,
@CAPIBLOCK_MODIFIEDBY ,
@CAPIBLOCK_MODIFIEDDT ,
@CAPIBLOCK_MODIFIEDH ,
@CAPIBLOCK_MODIFIEDM ,
@CAPIBLOCK_MODIFIEDS ,
@SITEID ,
@RECSTATUS ,
@ORGLOGICREF ,
@INDEMPAY ,
@SSKDISCLAW ,
@SSKDOCTYPE ,
@SSKDEPLAW ,
@FISERVADDRATIO)
yasak LH_001_LAWCHGSEQ SET LASTLREF = @NEWLREF WHERE ID=1
FETCH NEXT FROM lch
INTO @LREF ,
@PERREF ,
@JOBLNNR ,
@BEGDATE ,
@ENDDATE ,
@PERCODE ,
@FIRMNR ,
@LOCNR ,
@TYP ,
@ACTIVE ,
@OUTREASON ,
@OUTOPDATE ,
@BUFF ,
@INOK ,
@OUTOK ,
@REPSTATS1 ,
@REPSTATS2 ,
@REPSTATS3 ,
@REPSTATS4 ,
@REPSTATS5 ,
@REPSTATS6 ,
@REPSTATS7 ,
@REPSTATS8 ,
@REPSTATS9 ,
@REPSTATS10 ,
@REPSTATS11 ,
@REPSTATS12 ,
@REPSTATS13 ,
@REPSTATS14 ,
@REPSTATS15 ,
@REPSTATS16 ,
@SSKSTATUS ,
@SSKNO ,
@TTFNO ,
@FLAGS1 ,
@FLAGS2 ,
@FLAGS3 ,
@FLAGS4 ,
@FLAGS5 ,
@FLAGS6 ,
@FLAGS7 ,
@FLAGS8 ,
@EXP ,
@INJUREDEGREE ,
@OUTRIGHTS1 ,
@OUTRIGHTS2 ,
@OUTRIGHTS3 ,
@OUTRIGHTS4 ,
@OUTRIGHTS5 ,
@OUTRIGHTS6 ,
@OUTRIGHTS7 ,
@OUTRIGHTS8 ,
@OUTRIGHTS9 ,
@OUTRIGHTS10 ,
@OUTRIGHTS11 ,
@OUTRIGHTS12 ,
@OUTRIGHTS13 ,
@OUTRIGHTS14 ,
@OUTRIGHTS15 ,
@OUTRIGHTS16 ,
@OUTCOEF1 ,
@OUTCOEF2 ,
@OUTCOEF3 ,
@OUTCOEF4 ,
@OUTCOEF5 ,
@OUTCOEF6 ,
@OUTCOEF7 ,
@OUTCOEF8 ,
@OUTAMNT1 ,
@OUTAMNT2 ,
@OUTAMNT3 ,
@OUTAMNT4 ,
@OUTAMNT5 ,
@OUTAMNT6 ,
@OUTAMNT7 ,
@OUTAMNT8 ,
@FREEWGDAY ,
@CALCDATE ,
@LEGISLATIVE ,
@FROMOUT ,
@CALCDT ,
@ADDAID ,
@CAPIBLOCK_CREATEDBY ,
@CAPIBLOCK_CREATEDDT ,
@CAPIBLOCK_CREATEDH ,
@CAPIBLOCK_CREATEDM ,
@CAPIBLOCK_CREATEDS ,
@CAPIBLOCK_MODIFIEDBY ,
@CAPIBLOCK_MODIFIEDDT ,
@CAPIBLOCK_MODIFIEDH ,
@CAPIBLOCK_MODIFIEDM ,
@CAPIBLOCK_MODIFIEDS ,
@SITEID ,
@RECSTATUS ,
@ORGLOGICREF ,
@INDEMPAY ,
@SSKDISCLAW ,
@SSKDOCTYPE ,
@SSKDEPLAW ,
@FISERVADDRATIO
END
CLOSE lch
DEALLOCATE lch
PRINT convert (varchar(4),@RECNUM) + ' kayıt güncellendi.'