----BU 2  UPDATE ÇALIŞNCA CEKLER TAHSIL OLUYOR
UPDATE Ent_NARGAZ2022.dbo.CEK SET ISLEMNO=CEK2020.ISLEMNO,BORDRONO=CEK2020.BORDRONO
FROM Ent_NARGAZ2022.dbo.CEK AS CEK2022
INNER JOIN Ent_NARGAZ2020.dbo.CEK AS CEK2020 ON CEK2020.PORTFOYNO=CEK2022.PORTFOYNO AND CEK2020.CEKNO=CEK2022.CEKNO
WHERE CEK2020.CEKDURUM='Teminatta' AND CEK2022.CEKDURUM='Teminatta' 
AND CEK2022.CEKNO IN (SELECT CEKNO FROM Ent_NARGAZ2022.dbo.CEK WHERE CEKDURUM='Teminatta' )
-------

insert into Ent_NARGAZ2022.dbo.BORDRO (  BORDRONO, CEKNO, PORTFOYNO, EVRAKTUR, CEKDURUM, TARIH, OZELKOD, MUSKODU, MUSADI, TAKIPNO, VADETARIH, TUTAR, CIRO, BORCLU, ODEMEYERI, ODVERDA, ODNERNO, THESAPNO, HESAPNO, BANKA, 
                         TBANKA, BANKASUBE, TBANKASUBE, ACIKLAMA1, ACIKLAMA2, KEFIL, TANZIMTARIH, DURUM, BANKAHAVALE, ISLEMNO, MUSNO, DovizTut, DovizCinsi, DovizKodu, KULNO, KULADI, SaticiKodu, SaticiAdi, IslemTipi, AcikKapali, 
                         DovizBorc, DovizAlacak, Departman, GrupKodu, KayitDuzeyi
)

Select   BORDRONO, CEKNO, PORTFOYNO, EVRAKTUR, CEKDURUM, TARIH, OZELKOD, MUSKODU, MUSADI, TAKIPNO, VADETARIH, TUTAR, CIRO, BORCLU, ODEMEYERI, ODVERDA, ODNERNO, THESAPNO, HESAPNO, BANKA, 
                         TBANKA, BANKASUBE, TBANKASUBE, ACIKLAMA1, ACIKLAMA2, KEFIL, TANZIMTARIH, DURUM, BANKAHAVALE, ISLEMNO, MUSNO, DovizTut, DovizCinsi, DovizKodu, KULNO, KULADI, SaticiKodu, SaticiAdi, IslemTipi, AcikKapali, 
                         DovizBorc, DovizAlacak, Departman, GrupKodu, KayitDuzeyi
 from BORDRO as B20 where B20.CEKDURUM in ('Teminatta','Tahsilde') and
 (select count(*) from  Ent_NARGAZ2022.dbo.BORDRO  as B22 where B22.ISLEMNO=B20.ISLEMNO)=0



----------DENEMELER
select * from Ent_NARGAZ2020.dbo.BANKA where  BORDRONO = 828
select * from Ent_NARGAZ2020.dbo.BANKA where  BORDRONO = 841
select * from Ent_NARGAZ2022.dbo.BANKA where  BORDRONO = 828

select * from Ent_NARGAZ2022.dbo.CEK where CEKNO=5516556 
select * from Ent_NARGAZ2020.dbo.CEK where CEKNO in (
select CEKNO from Ent_NARGAZ2022.dbo.CEK where -- BORDRONO=1081 and 
Status=1 and CEKNO=5516556 )


select * from CEK where BORDRONO=1081 and TUTAR='15785'
select * from Ent_NARGAZ2022.dbo.CEK where PORTFOYNO=828
/*BANKA*/
ISLEMNO=93138 , ISLEMNO2=93918, BORDRONO=828, BORDRONO2=1062
/*ÇEK*/
BORDRONO= 1062,PORTFOYNO=828,ISLEMNO=93138, Status=1
/*2022 ÇEK*/
BORDRONO= 1081 /* Değişmiş*/ PORTFOYNO=828,ISLEMNO=96634 /* Değişmiş*/ ,Status=1

update Ent_NARGAZ2022.dbo.CEK set BORDRONO= 1062, ISLEMNO=93138, Status=1 where PORTFOYNO=828