http://www.erpne.org/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 16:10:23 +0000 Wed, 25 Jan 2012 16:04:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.10 360 www.erpne.org/RSS_post_feed.asp?TID=2956 http://www.erpne.org/forum_images/logotype.png http://www.erpne.org/ http://www.erpne.org/personel-yeni-aya-yila-devir_topic2956_post16426.html#16426 Yazar: ilker_15
Konu: 2956
Gönderim Zamanı: 25 Ocak 2012 Saat 16:04

Öncelikle ilgilendiginiz için tesekkür ederim söylediklerinizi bire bir dikkate alarak yaptim ancak degisen bisey olmadi. ]]> Wed, 25 Jan 2012 16:04:06 +0000 http://www.erpne.org/personel-yeni-aya-yila-devir_topic2956_post16426.html#16426 http://www.erpne.org/personel-yeni-aya-yila-devir_topic2956_post16425.html#16425 Yazar: mbaykan
Konu: 2956
Gönderim Zamanı: 25 Ocak 2012 Saat 15:51

çok emin degilim PERSONEL database'ine bakmayali uzun zaman oldu.
numeric verileri Varchar tipindeki kolonlarda sakladigi bir tablo TBLKARTX
buradaki sayilarda ondalik/bindelik ayraçlardan kaynaklanabilir mi?
186 sicilli kayitta 5.59000000000003 degerini yuvarlayin (5.59) bir kaç kez geçiyor olmali
Error converting data type varchar to numeric. mesaji, numeric çevrimine alamadigi (uzun küsuratlar) nedeniyledir (bundan da çok emin degilim)
eger Veri'nizden kaynakli bir sorun oldugunu anlarsaniz SQL'den manuel düzeltip
programi tekrar çalistirin

]]> Wed, 25 Jan 2012 15:51:04 +0000 http://www.erpne.org/personel-yeni-aya-yila-devir_topic2956_post16425.html#16425 http://www.erpne.org/personel-yeni-aya-yila-devir_topic2956_post16424.html#16424 Yazar: ilker_15
Konu: 2956
Gönderim Zamanı: 25 Ocak 2012 Saat 14:36

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)
]]> Wed, 25 Jan 2012 14:36:47 +0000 http://www.erpne.org/personel-yeni-aya-yila-devir_topic2956_post16424.html#16424