delete from CARI_HESAP_HAREKETLERI
delete from STOK_HAREKETLERI
DELETE FROM STOK_HAREKETLERI_EK
DELETE FROM STOK_HAREKETLERI_OZET
DELETE FROM CARI_HESAP_HAREKETLERI_EK
delete from ODEME_EMIRLERI

DELETE FROM CARI_HESAP_HAREKETLERI_OZET
exec msp_CARI_HESAP_HAREKETLERI_OZET_Update
DELETE FROM STOK_HAREKETLERI_OZET
exec msp_STOK_HAREKETLERI_OZET_Update
DELETE FROM SIPARISLER_OZET
exec msp_SIPARISLER_OZET_Update

UPDATE CARI_HESAP_HAREKETLERI SET cha_ciro_cari_kodu='',cha_karsidgrupno='1',cha_uuid='' where cha_evrak_tip IN(34,35)

USE [REKOR 2019]
go
delete FROM TMP_LOG
delete FROM TMP_STOK
delete FROM TMP_CARI

delete FROM TMP_CARI_1

delete FROM TMP_CARI_2

delete FROM TMP_CARI_3

delete FROM TMP_CARI_4

delete FROM TMP_CARI_5

delete FROM TMP_CARI_6

delete FROM TMP_CARI_7

delete FROM TMP_CARI_8

delete FROM TMP_CARI_9

delete FROM TMP_CARI_10

delete FROM TMP_CARI_11

delete FROM TMP_CARI_12

delete FROM TMP_CARI_13
delete FROM TMP_STOK_14
delete FROM TMP_CARI_14
delete FROM TMP_STOK_15
delete FROM TMP_CARI_15
delete FROM TMP_STOK_16
delete FROM TMP_CARI_16
delete FROM TMP_STOK_17
delete FROM TMP_CARI_17


delete FROM TMP_STOK_19
delete FROM TMP_CARI_19
delete FROM TMP_STOK_20
delete FROM TMP_CARI_20