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
-------------
İnnova Antalya Proje Danışmanlık
Orhan ÇÖPÜROĞLU
0544 241 45 55
0242 311 45 56
|