DECLARE @NO nvarchar (200) --443141 =65 , 443149=97 , 443157=32 , 443163=430
set @NO= ('442527')  --,('443149','443157' , '443163' , 443141) ---'440897'   -- fişten gelen 440177,428565,437479
select 'sd' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Tutar,KdvTutari ,CariNo,CariAdi,IslemTuru,FisTuru,eFaturaNo,UUID  from STOKHARDETBAG  WHERE (IslemNo3 IN (@NO) or  IslemNo IN  (@NO))  
select 'SH',sum(SonTutar ) from STOKHAR WHERE   (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO)) 
select 'AC',BORC,ALACAK,MUSKOD,BAACIKLA FROM ACARI WHERE ISLEMNO=@NO
select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru,FisTuru  from STOKHAR WHERE   (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO))
select IslemNo,IslemNo3, sum(SonTutar ) from STOKHAR WHERE   (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO))  group by IslemNo,IslemNo3
select 'log',* from  EntegreLog where IslemNo=@NO
--select IslemNo,IslemNo3,SonTutar from STOKHAR where IslemNo=@NO or IslemNo3=@NO
select 'SH',(SonTutar ),IslemNo3,IslemNo,* from STOKHAR WHERE   (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO)) 

--SELECT * FROM STOKHAR WHERE NoId BETWEEN   224655 AND 224695 ORDER BY NoId,IslemNo
--SELECT * FROM Ent_A40411.dbo.STOKHAR WHERE NoId BETWEEN   224655 AND 224695 ORDER BY NoId,IslemNo


--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Tutar,KdvTutari ,CariNo,CariAdi,IslemTuru  from STOKHARDETBAG  WHERE (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO))  union
--select 'E',IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Tutar,KdvTutari ,CariNo ,CariAdi ,IslemTuru from Ent_A40403.dbo.STOKHARDETBAG  WHERE   (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO)) ORDER BY IslemNo
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Tutar,KdvTutari ,CariNo,CariAdi,IslemTuru  from STOKHARDETBAG  WHERE (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO))   union
--select 'E',IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Tutar,KdvTutari ,CariNo ,CariAdi ,IslemTuru from Ent_A40403.dbo.STOKHARDETBAG  WHERE  (IslemNo3 IN  (@NO) or  IslemNo IN  (@NO))  ORDER BY NoId

--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru  from STOKHAR WHERE   (IslemNo3 BETWEEN (@NO-3) AND (@NO+3) or  IslemNo BETWEEN (@NO-3) AND (@NO+3))  union
--select 'E',IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo ,CariAdi ,IslemTuru from Ent_A40403.dbo.STOKHAR WHERE   (IslemNo3 BETWEEN (@NO-3) AND (@NO+3) or  IslemNo BETWEEN (@NO-3) AND (@NO+3))  ORDER BY IslemNo
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru  from STOKHAR WHERE  (IslemNo3 BETWEEN (@NO-3) AND (@NO+3) or  IslemNo BETWEEN (@NO-3) AND (@NO+3))   union
--select 'E',IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo ,CariAdi ,IslemTuru from Ent_A40403.dbo.STOKHAR WHERE   (IslemNo3 BETWEEN (@NO-3) AND (@NO+3) or  IslemNo BETWEEN (@NO-3) AND (@NO+3))   ORDER BY NoId
--443163
--443157 443149 443141 İŞLLEM NOLARA BAK
--select TOP 3 IslemNo,IslemNo3,CariNo ,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru  
--from STOKHAR ORDER BY NoId DESC
--SELECT ISLEMNO,FATURANO ,(select MAX(IslemNo) from STOKHAR ) SHNO, (select MAX(IslemNo) from STOKHARDETBAG) SDNO, (select MAX(ISLEMNO) from ACARI) ACNO FROM ADIGSABITLER 

--select top 4 IslemNo, IslemNo3,IrsNo,CariNo,FaturaNo,Tutar,KdvTutari,IslemTuru
--from STOKHARDETBAG order by IslemNo desc

--select h.IslemNo,h.IslemNo3,h.SonTutar,h.FaturaNo,d.IslemNo d_ino,h.CariNo,d.CariNo, d.FaturaNo d_Fno, d.IrsNo d_irsno,h.SonTutar,h.KdvTutari from STOKHAR h left join STOKHARDETBAG d on h.IslemNo=d.IslemNo 
--WHERE h.IslemNo IN 
--(select top 4 IslemNo from STOKHARDETBAG  ORDER  BY IslemNo DESC )-- AND h.CariNo=695 

--DECLARE @NO nvarchar (200) --443141 =65 , 443149=97 , 443157=32 , 443163=430
--set @NO= ('321')  --,('443149','443157' , '443163' , 443141) ---'440897'   -- fişten gelen 440177,428565,437479
--select 'sd' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Tutar,KdvTutari ,CariNo,CariAdi,IslemTuru,FisTuru  from STOKHARDETBAG  WHERE CariNo=@NO  
--select 'SH',sum(SonTutar ) from STOKHAR WHERE   CariNo=@NO
--select 'AC',BORC,ALACAK,MUSKOD,BAACIKLA FROM ACARI WHERE MUSNO=@NO
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru,FisTuru  from STOKHAR WHERE   CariNo=@NO
--select IslemNo,IslemNo3, sum(SonTutar ) from STOKHAR WHERE   CariNo=@NO  group by IslemNo,IslemNo3

-----İKİ DB ARASI CARİNOLARA GÖRE HAREKET FARKI KONTROLU
--DECLARE @NO nvarchar (200)=321 --443141 =65 , 443149=97 , 443157=32 , 443163=430
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru,FisTuru  from STOKHAR WHERE   CariNo=@NO
--EXCEPT
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru,FisTuru  from Ent_A40403.dbo.STOKHAR WHERE   CariNo=@NO
--union
--DECLARE @NO nvarchar (200)=321 --443141 =65 , 443149=97 , 443157=32 , 443163=430
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru,FisTuru  from Ent_A40403.dbo.STOKHAR WHERE   CariNo=@NO
--EXCEPT
--select 'Y' AS DB,IslemNo,IslemNo3,NoId,FaturaTarihi,SiparisTarihi ,Miktar,SonTutar,SonTutarDov,Kdv,KdvTutari ,StokKodu,CariNo,CariAdi,IslemTuru,FisTuru  from STOKHAR WHERE   CariNo=@NO