Yeni aya/yila devir yaparken asagidaki hatayi veriyor. TBLPUANTAJ,kartx baktim kayitlarda bir sorun görünmüyor ayrica asagidaki kodu sqlde çalistirdigimda hata vermiyor. Set güncelledim ama genede ise yaramadi. Baska ne yapabilirim yardimci olabilirmisiniz. Tesekkür ederim.
Islem Tamamlanamadi !...
Islem Tamamlanamadi...!
SQL : Begin
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '178', 2011, 12, 30.0, 0.0, 838.0, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 125.7, 188.55, 838.0, 1373.31, 81.35, 838.0, 625.42, 542.3, 838.0, 5.53, 0.0, 0.0, 41.9, 0.0, 75.42, 8.38, 0.0, 16.76, 0.0, 62.85, 0.0, 92.18, 16.76, 0.0, 0.0, 0.0,0.0, 0.0, 171.585, 0.0, 17.1585, 838.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 206.0065 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '178';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '179', 2011, 12, 30.0, 0.0, 894.43, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 134.16, 201.25125, 838.0, 2149.25, 114.04, 894.43, 640.33, 760.27, 838.0, 5.9, 0.0, 0.0, 44.72, 0.0, 80.5, 8.94, 0.0, 17.8886, 0.0, 67.08375, 0.0, 98.386, 17.8929, 0.0, 0.0, 56.43,0.0, 0.0, 0.0, 0.0, 0.0, 838.0, 56.43, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 322.392 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '179';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '180', 2011, 12, 30.0, 0.0, 867.05, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 130.06, 195.08375, 838.0, 1188.11, 110.55, 867.05, 620.72, 736.99, 838.0, 5.72, 0.0, 0.0, 43.35, 0.0, 78.03, 8.67, 0.0, 17.341, 0.0, 65.03125, 0.0, 95.38, 17.3415, 0.0, 0.0, 29.05,0.0, 0.0, 0.0, 0.0, 0.0, 838.0, 29.05, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 178.22 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '180';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '181', 2011, 12, 30.0, 0.0, 964.82, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 144.72, 217.0875, 838.0, 962.56, 123.02, 964.82, 690.71, 820.1, 838.0, 6.37, 0.0, 0.0, 48.24, 0.0, 86.83, 9.65, 0.0, 19.2964, 0.0, 72.3625, 0.0, 106.134, 19.2946, 0.0, 0.0, 126.82,0.0, 0.0, 0.0, 0.0, 0.0, 838.0, 126.82, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 144.39 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '181';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '182', 2011, 12, 30.0, 0.0, 867.05, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 130.06, 195.08375, 838.0, 784.48, 110.55, 867.05, 620.72, 736.99, 838.0, 5.72, 0.0, 0.0, 43.35, 0.0, 78.03, 8.67, 0.0, 17.341, 0.0, 65.03125, 0.0, 95.38, 17.3415, 0.0, 0.0, 29.05,0.0, 0.0, 0.0, 0.0, 0.0, 838.0, 29.05, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICIL SET SICGV_KUM = 0.0, SICFATTUT = 0.0, SICGV_MAT = 0.0, SICKES_KUM_ISCI = 0.0, SICKES_KUM_ISVR = 0.0, SICKES_KUM_AY = 0, SICOZELINDMAT = 0.0, SICOZELINDGV = 117.67, SICKALANIND = 0.0 WHERE ISYERI = 'DEFNEMRK' AND SICILNO = '182';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '183', 2011, 12, 30.0, 0.0, 867.05, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 130.06, 195.08375, 838.0, 784.48, 110.55, 867.05, 620.72, 736.99, 838.0, 5.72, 0.0, 0.0, 43.35, 0.0, 78.03, 8.67, 0.0, 17.341, 0.0, 65.03125, 0.0, 95.38, 17.3415, 0.0, 0.0, 29.05,0.0, 0.0, 0.0, 0.0, 0.0, 838.0, 29.05, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICIL SET SICGV_KUM = 0.0, SICFATTUT = 0.0, SICGV_MAT = 0.0, SICKES_KUM_ISCI = 0.0, SICKES_KUM_ISVR = 0.0, SICKES_KUM_AY = 0, SICOZELINDMAT = 0.0, SICOZELINDGV = 117.67, SICKALANIND = 0.0 WHERE ISYERI = 'DEFNEMRK' AND SICILNO = '183';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '184', 2011, 12, 25.0, 0.0, 698.33, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 104.75, 157.12375, 838.0, 593.58, 89.04, 698.33, 499.93, 593.58, 698.33, 4.61, 0.0, 0.0, 34.92, 0.0, 62.85, 6.98, 0.0, 13.9666, 0.0, 52.37125, 0.0, 76.816, 13.9699, 0.0, 0.0, 0.0,0.0, 0.0, 0.0, 0.0, 0.0, 698.33, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICIL SET SICGV_KUM = 0.0, SICFATTUT = 0.0, SICGV_MAT = 0.0, SICKES_KUM_ISCI = 0.0, SICKES_KUM_ISVR = 0.0, SICKES_KUM_AY = 0, SICOZELINDMAT = 0.0, SICOZELINDGV = 89.04, SICKALANIND = 0.0 WHERE ISYERI = 'DEFNEMRK' AND SICILNO = '184';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '185', 2011, 12, 27.0, 0.0, 986.05, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 147.91, 221.85875, 838.0, 838.14, 125.72, 986.05, 705.91, 838.14, 754.2, 6.51, 0.0, 0.0, 49.3, 0.0, 88.74, 9.86, 0.0, 19.721, 0.0, 73.95625, 0.0, 108.47, 19.7215, 0.0, 0.0, 231.85,0.0, 0.0, 0.0, 0.0, 0.0, 754.2, 231.85, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 125.72 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '185';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '186', 2011, 12, 25.0, 0.0, 703.92, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 105.59, 158.38, 838.0, 598.33, 89.75, 703.92, 503.93, 598.33, 698.33, 4.65, 0.0, 0.0, 35.2, 0.0, 63.35, 7.04, 0.0, 14.0784, 0.0, 52.79, 0.0, 77.434, 14.0776, 0.0, 0.0, 5.59000000000003,0.0, 0.0, 0.0, 0.0, 0.0, 698.33, 5.59000000000003, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 89.75 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '186';
INSERT INTO KARTX (ISYERI, SICILNO, YIL, AY, NORMAL_GUN, IZIN_GUN, NORMAL_MAT, IZIN_MAT, MADEN_GUN, MADEN_MAT, TASISCI, TASISVR, Konut, sskisci, sskisvr, ucret, kumgvmat, gv, brut, net, aygvmat, normalkaz, DV, sgdp_isci, analik_isci, hastalik_isci, hastalik_cirak_isci, malulluk_isci, issizlik_isci, sgdp_isvr, iskazalari_isvr, analik_isvr, hastalik_isvr, hastalik_cirak_isvr, malulluk_isvr, issizlik_isvr,Maden_isci,Maden_isvr, EKKAZ,F_YEDEK1, F_YEDEK2, F_YEDEK3, F_YEDEK4, F_YEDEK5, SSKISVRUCRET, SSKISVRIKRAMIYE, ARGE_TERKIN_TUTAR, KUM_ARGE_GV_MAT, AY_ARGE_GV_MAT, KUM_ARGE_ISTISNA_MAT, AY_ARGE_ISTISNA_MAT, ARGE_GUN, K5921_GM9_TERKIN_TUTAR, ARGE_GV_TERKIN_TUTAR, K6111_GM10_TERKIN_TUTAR) VALUES ('DEFNEMRK', '187', 2011, 12, 9.0, 0.0, 251.4, 0.0, 0.0,0.0,0.0, 0.0, 0.0, 37.71, 56.565, 838.0, 213.69, 32.05, 251.4, 179.98, 213.69, 251.4, 1.66, 0.0, 0.0, 12.57, 0.0, 22.63, 2.51, 0.0, 5.028, 0.0, 18.855, 0.0, 27.65, 5.032, 0.0, 0.0, 0.0,0.0, 0.0, 0.0, 0.0, 0.0, 251.4, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,0.0,0.0);
UPDATE SICILAY SET TERSBAKIYE = 0.0, YUVARLAMAFARKI = 0.0, GV_KUM = 0.0, FATTUT = 0.0, GV_MAT = 0.0, ARGE_GV_MAT = 0.0, ARGE_ISTISNA_MAT = 0.0, BRUT_KUM = 0.0, KES_KUM_ISCI = 0.0, KES_KUM_ISVR = 0.0, KES_KUM_AY = 0, KALANIND = 0.0, BORCU = 0.0, BORCTAK = 0.0, BORCFAIZ = 0.0, OZELINDMAT = 0.0, OZELINDGV = 32.05 WHERE ISYERI = 'DEFNEMRK' AND YIL = 2012 AND AY = 1 AND AYICI = 0 AND SICILNO = '187';
End;
Error converting data type varchar to numeric.(NetsisMS-22018,8114)
|