ADMIN Firma_Demo2 C:\Program Files (x86)\Comarch OPT!MA 10 130 30 False True , -1 -1 -1 -1 -1 -1 -1 -1 0 0 0 0 TrN_TypDokumentu = 308 and TrN_DDfId= 17 60 301000 301 SZYM-PC\SQLEXPRESS CDN_Firma_Demo2 sa szymek1234 http://api.smsapi.pl/sms.do? szymekp 6a827533c78cffff6e1bf67a5ea136e6 True False False True 0 2 TrN_TypDokumentu=303 and TrN_TrNId not in (select Exp_TrNId from dbo.TrnExport) 1 INSERT INTO [dbo].[TrnExport]([Exp_TrNId],[Exp_TS],[Exp_OptId],[Exp_IscId]) VALUES (@TrN_Id, CURRENT_TIMESTAMP, @Opt_Id, @Sch_Id ) Urządzenie gotowe do odbioru 1914 False , select * from dbo.migrKnt where KOD NOT IN ( select Knt_Kod from CDN.Kontrahenci) and LEN(Kod)>0 select * from dbo.migrCeny select * from dbo.migrStany where TwrKod COLLATE Polish_CI_AS in (select Twr_Kod from CDN.Towary) False False TrN_TypDokumentu = 308 and TrN_DDfId= 17 True False False SELECT TrN_TrNID ,TrN_TypDokumentu,TrN_Anulowany,TrN_Rodzaj ,TrN_DataDok,TrN_DataWys,TrN_DataOpe ,TrN_NumerPelny,TrN_PodNipKraj,TrN_PodNipE,TrN_PodmiotGLN , TrN_RazemNetto, TrN_RazemVAT, TrN_RazemBrutto , MAG_Symbol, TrN_Korekta,ISNULL( Exp_OptId,0) TrN_ZwrIdOpt FROM CDN.TraNag JOIN CDN.Magazyny ON TrN_MagZrdId = MaG_MAGID LEFT OUTER JOIN dbo.TrnExport ON TrN_ZwrId = Exp_TrNId 17 True C:\OptimaExtConfig\ 0 0 0 0 0