Personel sicil kodu degisikligi

onceden yapmistim, degisiklikler olabilir.


DROP PROC INN_P_SICILNODEGIS
GO
CREATE PROC INN_P_SICILNODEGIS
(@ISYERI NVARCHAR(15), @ESKI NVARCHAR(15), @YENI NVARCHAR(15))
AS
BEGIN
    
    INSERT INTO TBLSICIL
    (ISYERI, SICILNO, GIRISTAR, CIKISTAR, AYRILIS_KODU, AYRILIS_NEDENI, IHBAR_VAR, TAS_HESNO, OKUL_ONCESI_COCUK, ILKOKUL_COCUK,
                      ORTA_COCUK, LISE_COCUK, YUKSEK_COCUK, IND_DILEK, DETAY_KOD, CARIMUHKOD, GOREV_KODU, KAYITTAR, KAYITYAPAN, UPDATETAR,
                      UPDATEYAPAN, FATTUT, ILKISYERI, ILKSICILNO, SICUCRETI, SICUCRET_NEVI, SICNETI, SICNETTENGIT, SICDOVIZ_MAAS, SICDOVIZ_CINSI,
                      SICGV_KUM, SICGV_MAT, SICKES_KUM_ISCI, SICKES_KUM_ISVR, SICKES_KUM_AY, SICOZELINDMAT, SICOZELINDGV, SICFATTUT, SICTAS_VAR,
                      SICKALANIND, HRINTCODE, TERFITARIH, SICSSKKANUN, SICSSKBELGE, GECINDORAN, GV_TERKIN, ISVR_TERKIN, YEDEK1_TERKIN,
                      YEDEK2_TERKIN, K5763_M20_TERKIN, K5763_M24_TERKIN, ARGE_CALISMA_SURE, ARGE_MUAF_ORAN, K5921_GM9_TERKIN,
                      K6111_GM10_TERKIN, K6111_GM10_TERKIN_TARIH, K6111_GM10_TERKIN_SURE, K5921_EM2_TERKIN, EKKIDEMGUNSAY, OZLUKID, IBAN_1,
                      IBAN_2, IBAN_3, IBAN_4)
    SELECT ISYERI, @YENI, GIRISTAR, CIKISTAR, AYRILIS_KODU, AYRILIS_NEDENI, IHBAR_VAR, TAS_HESNO, OKUL_ONCESI_COCUK, ILKOKUL_COCUK,
                      ORTA_COCUK, LISE_COCUK, YUKSEK_COCUK, IND_DILEK, DETAY_KOD, CARIMUHKOD, GOREV_KODU, KAYITTAR, KAYITYAPAN, UPDATETAR,
                      UPDATEYAPAN, FATTUT, ILKISYERI, ILKSICILNO, SICUCRETI, SICUCRET_NEVI, SICNETI, SICNETTENGIT, SICDOVIZ_MAAS, SICDOVIZ_CINSI,
                      SICGV_KUM, SICGV_MAT, SICKES_KUM_ISCI, SICKES_KUM_ISVR, SICKES_KUM_AY, SICOZELINDMAT, SICOZELINDGV, SICFATTUT, SICTAS_VAR,
                      SICKALANIND, HRINTCODE, TERFITARIH, SICSSKKANUN, SICSSKBELGE, GECINDORAN, GV_TERKIN, ISVR_TERKIN, YEDEK1_TERKIN,
                      YEDEK2_TERKIN, K5763_M20_TERKIN, K5763_M24_TERKIN, ARGE_CALISMA_SURE, ARGE_MUAF_ORAN, K5921_GM9_TERKIN,
                      K6111_GM10_TERKIN, K6111_GM10_TERKIN_TARIH, K6111_GM10_TERKIN_SURE, K5921_EM2_TERKIN, EKKIDEMGUNSAY, OZLUKID, IBAN_1,
                      IBAN_2, IBAN_3, IBAN_4 FROM TBLSICIL (NOLOCK)
                      WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    PRINT 'SICIL'
    INSERT INTO TBLSICILAY
    (ISYERI, SICILNO, YIL, AY, AYICI, HESAPKODU, UCRETI, UCRET_NEVI, TAS_VAR, TASGERI, SENDIKA, ISCI_MEMUR, KES_DEV_ISCI, KES_DEV_ISVR,
                      KES_DEV_MAT, DEV_IZIN_GUN, DEV_NORMAL_GUN, DEV_NORMAL_MAT, DEV_IZIN_MAT, DEV_NORMAL_IMA, DEV_IZIN_IMA, DEV_SSK_ISCI_NORM,
                       DEV_SSK_ISVR_NORM, DEV_SSK_ISCI_IZIN, DEV_SSK_ISVR_IZIN, NETI, NETTENGIT, DOVIZ_MAAS, DOVIZ_CINSI, TERSBAKIYE, YUVARLAMAFARKI,
                      GV_KUM, GV_MAT, BRUT_KUM, KONUT_FONU, KONUT_AY_SAY, KES_KUM_ISCI, KES_KUM_ISVR, KES_KUM_AY, OZELINDMAT, OZELINDGV,
                      FATTUT, KALANIND, BORCU, BORCTAK, BORCFAIZ, DEV_MADEN_GUN, DEV_MADEN_MAT, DEV_MADEN_IMA, DEV_MADEN_ISCI, DEV_MADEN_ISVR,
                      ILKISYERI, ILKSICILNO, DOGRUDANGIDER, SSK_DURUM, MEDENIHAL, COCUK_ADEDI, GOCMEN, SAKATLIK_DRC, OKUL_ONCESI_COCUK,
                      ILKOKUL_COCUK, ORTA_COCUK, LISE_COCUK, YUKSEK_COCUK, PROJEKODU, SSKKANUN, SSKBELGE, GV_COCUK_ADEDI,
                      GV_OKUL_ONCESI_COCUK, GV_ILKOKUL_COCUK, GV_ORTA_COCUK, GV_LISE_COCUK, GV_YUKSEK_COCUK, SSK_COCUK_ADEDI,
                      SSK_OKUL_ONCESI_COCUK, SSK_ILKOKUL_COCUK, SSK_ORTA_COCUK, SSK_LISE_COCUK, SSK_YUKSEK_COCUK, GV_AILE, SSK_AILE, IND_DILEK,
                      S_YEDEK1, S_YEDEK2, F_YEDEK1, F_YEDEK2, C_YEDEK1, C_YEDEK2, B_YEDEK1, I_YEDEK1, L_YEDEK1, KAYITYAPANKUL, KAYITTARIHI,
                      DUZELTMEYAPANKUL, DUZELTMETARIHI, F_YEDEK3, F_YEDEK4, F_YEDEK5, DEV_SSK_ISVR_UCRET, DEV_SSK_ISVR_IKRAMIYE,
                      DEV_SSK_ISC_UCRET, DEV_SSK_ISC_IKRAMIYE, DEV_BIRAYONCEDEN_SARF, DEV_IKIAYONCEDEN_SARF, DEV_K5510M80_SARKAN,
                      DEV_SSK_TABI_UCRET, DEV_SSK_TABI_YARDIM, GV_TERKIN, ISVR_TERKIN, YEDEK1_TERKIN, YEDEK2_TERKIN, K5763_M20_TERKIN,
                      K5763_M24_TERKIN, DEV_ARGE_TERKIN_TUTAR, ARGE_CALISMA_SURE, ARGE_GV_MAT, ARGE_ISTISNA_MAT, DEV_ARGE_GUN,
                      ARGE_MUAF_ORAN, DEV_SSK_TABI_MADEN_UCRET, DEV_SSK_TABI_IZIN_UCRET, DEV_BIRAYONCEDEN_NET_SARF,
                      DEV_IKIAYONCEDEN_NET_SARF, DEV_K5510M80_NET_SARKAN, DEV_SSK_TABI_NET_YARDIM, DEV_NETEEKLENECEKSARKANTUTAR,
                      K5921_GM9_TERKIN_TUTAR, K5921_GM9_TERKIN, ARGE_GV_TERKIN_TUTAR, DERECE1_YAKIN_SAYISI, DERECE2_YAKIN_SAYISI,
                      DERECE3_YAKIN_SAYISI, DEV_ARGE_K5510M80_SARKAN, DEV_ARGE_SSK_TABI_YARDIM, DEV_ARGE_BIRAYONCEDEN_SARF,
                      DEV_ARGE_IKIAYONCEDEN_SARF, K6111_GM10_TERKIN_TUTAR, K6111_GM10_TERKIN, K6111_GM10_TERKIN_TARIH,
                      K6111_GM10_TERKIN_SURE, K5921_EM2_TERKIN_TUTAR, K5921_EM2_TERKIN, MUHREFKOD)
    SELECT     ISYERI, @YENI, YIL, AY, AYICI, HESAPKODU, UCRETI, UCRET_NEVI, TAS_VAR, TASGERI, SENDIKA, ISCI_MEMUR, KES_DEV_ISCI, KES_DEV_ISVR,
                      KES_DEV_MAT, DEV_IZIN_GUN, DEV_NORMAL_GUN, DEV_NORMAL_MAT, DEV_IZIN_MAT, DEV_NORMAL_IMA, DEV_IZIN_IMA, DEV_SSK_ISCI_NORM,
                       DEV_SSK_ISVR_NORM, DEV_SSK_ISCI_IZIN, DEV_SSK_ISVR_IZIN, NETI, NETTENGIT, DOVIZ_MAAS, DOVIZ_CINSI, TERSBAKIYE, YUVARLAMAFARKI,
                      GV_KUM, GV_MAT, BRUT_KUM, KONUT_FONU, KONUT_AY_SAY, KES_KUM_ISCI, KES_KUM_ISVR, KES_KUM_AY, OZELINDMAT, OZELINDGV,
                      FATTUT, KALANIND, BORCU, BORCTAK, BORCFAIZ, DEV_MADEN_GUN, DEV_MADEN_MAT, DEV_MADEN_IMA, DEV_MADEN_ISCI, DEV_MADEN_ISVR,
                      ILKISYERI, ILKSICILNO, DOGRUDANGIDER, SSK_DURUM, MEDENIHAL, COCUK_ADEDI, GOCMEN, SAKATLIK_DRC, OKUL_ONCESI_COCUK,
                      ILKOKUL_COCUK, ORTA_COCUK, LISE_COCUK, YUKSEK_COCUK, PROJEKODU, SSKKANUN, SSKBELGE, GV_COCUK_ADEDI,
                      GV_OKUL_ONCESI_COCUK, GV_ILKOKUL_COCUK, GV_ORTA_COCUK, GV_LISE_COCUK, GV_YUKSEK_COCUK, SSK_COCUK_ADEDI,
                      SSK_OKUL_ONCESI_COCUK, SSK_ILKOKUL_COCUK, SSK_ORTA_COCUK, SSK_LISE_COCUK, SSK_YUKSEK_COCUK, GV_AILE, SSK_AILE, IND_DILEK,
                      S_YEDEK1, S_YEDEK2, F_YEDEK1, F_YEDEK2, C_YEDEK1, C_YEDEK2, B_YEDEK1, I_YEDEK1, L_YEDEK1, KAYITYAPANKUL, KAYITTARIHI,
                      DUZELTMEYAPANKUL, DUZELTMETARIHI, F_YEDEK3, F_YEDEK4, F_YEDEK5, DEV_SSK_ISVR_UCRET, DEV_SSK_ISVR_IKRAMIYE,
                      DEV_SSK_ISC_UCRET, DEV_SSK_ISC_IKRAMIYE, DEV_BIRAYONCEDEN_SARF, DEV_IKIAYONCEDEN_SARF, DEV_K5510M80_SARKAN,
                      DEV_SSK_TABI_UCRET, DEV_SSK_TABI_YARDIM, GV_TERKIN, ISVR_TERKIN, YEDEK1_TERKIN, YEDEK2_TERKIN, K5763_M20_TERKIN,
                      K5763_M24_TERKIN, DEV_ARGE_TERKIN_TUTAR, ARGE_CALISMA_SURE, ARGE_GV_MAT, ARGE_ISTISNA_MAT, DEV_ARGE_GUN,
                      ARGE_MUAF_ORAN, DEV_SSK_TABI_MADEN_UCRET, DEV_SSK_TABI_IZIN_UCRET, DEV_BIRAYONCEDEN_NET_SARF,
                      DEV_IKIAYONCEDEN_NET_SARF, DEV_K5510M80_NET_SARKAN, DEV_SSK_TABI_NET_YARDIM, DEV_NETEEKLENECEKSARKANTUTAR,
                      K5921_GM9_TERKIN_TUTAR, K5921_GM9_TERKIN, ARGE_GV_TERKIN_TUTAR, DERECE1_YAKIN_SAYISI, DERECE2_YAKIN_SAYISI,
                      DERECE3_YAKIN_SAYISI, DEV_ARGE_K5510M80_SARKAN, DEV_ARGE_SSK_TABI_YARDIM, DEV_ARGE_BIRAYONCEDEN_SARF,
                      DEV_ARGE_IKIAYONCEDEN_SARF, K6111_GM10_TERKIN_TUTAR, K6111_GM10_TERKIN, K6111_GM10_TERKIN_TARIH,
                      K6111_GM10_TERKIN_SURE, K5921_EM2_TERKIN_TUTAR, K5921_EM2_TERKIN, MUHREFKOD
FROM         TBLSICILAY
WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    
    UPDATE TBLSICILEK SET SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE ES_COCUK SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE TBLGIRCIK SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE TBLKARTX SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    DELETE FROM TBLKIDEM WHERE (ISYERI = @ISYERI) AND SICILNO = @YENI
    UPDATE TBLKIDEM SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE TBLKIDEMPUA SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLMUHDETAY SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLNEMA SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLSABITKYK SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLBANKABCK SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLBANKA SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE TBLPUAN SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    PRINT '1'
    UPDATE TBLPUANTAJ SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLFPUAN SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLFPUANTAJ SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE TBLK5510M80SARKAN SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    
    UPDATE TBLFK5510M80SARKAN SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLHARCTRA SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLSICIZIN SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
    UPDATE TBLGUNDEVAM SET  SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI

    UPDATE EVRAK SET KOD = @ISYERI+@YENI WHERE TABLOTIPI=3 AND KOD = @ISYERI+@ESKI

    UPDATE TBLOZLUK SET SICILNO = @YENI WHERE SICILNO=@ESKI AND ISYERI=@ISYERI

    DELETE FROM TBLSICIL WHERE SICILNO=@ESKI AND ISYERI=@ISYERI
END