create TRIGGER TRG_Muhasebe_Kartac ON CARI_HESAPLAR
AFTER INSERT, UPDATE, DELETE AS

	DECLARE @INSERT AS CHAR(1) = (CASE WHEN EXISTS(SELECT * FROM INSERTED) AND NOT EXISTS(SELECT * FROM DELETED) THEN 'E' ELSE 'H' END)
	DECLARE @UPDATE AS CHAR(1) = (CASE WHEN EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED) THEN 'E' ELSE 'H' END)
	DECLARE @DELETE AS CHAR(1) = (CASE WHEN NOT EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED) THEN 'E' ELSE 'H' END)
a
	IF @INSERT = 'E' BEGIN
		INSERT INTO MUHASEBE_HESAP_PLANI (muh_Guid, muh_fileid, muh_create_user, muh_create_date, muh_lastup_user, muh_lastup_date, muh_hesap_kod, muh_hesap_isim1, muh_hesap_tip, muh_calisma_sekli,
		muh_SpecRECno, muh_iptal, muh_hidden, muh_kilitli, muh_degisti, muh_checksum, muh_special1, muh_special2, muh_special3, muh_hesap_isim2, muh_doviz_cinsi, muh_kurfarki_fl, muh_sorum_merk, muh_kilittarihi, muh_hes_dav_bicimi, muh_kdv_tipi, muh_maliyet_dagitim_sekli, muh_grupkodu, muh_enf_fark_maliyet_fl, muh_kdv_dagitim_sekli, muh_miktar_oto_fl, muh_ticariden_bilgi_girisi_fl, muh_proje_detayi, muh_kesin_mizan_hesap_kodu)
		 SELECT NEWID(), 1, 1, GETDATE(), 1, GETDATE(), cari_kod, cari_unvan1, 0, 1,
		 0, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, 0, CONVERT(DATE, '30.12.1899', 104), 0, 0, 0, '', 0, 0, 0, 0, 0, ''
		FROM INSERTED

		UPDATE T SET t.cari_muh_kod = I.cari_kod
		FROM CARI_HESAPLAR AS T
		INNER JOIN INSERTED AS I ON T.cari_kod = I.cari_kod
	END