C:\DibalCom\ True True False select Twr_Nazwa Nazwa,Twr_EAN PLU , ISNULL(Cena1.TwC_Wartosc,0) Cena1, ISNULL(Cena2.TwC_Wartosc,0) Cena2, ISNULL(Cena3.TwC_Wartosc,0) Cena3, CAST (CAST ( ISNULL(TwA_WartoscTxt,0) as float ) as int) KlawiszSkrot from CDN.Towary LEFT OUTER JOIN CDN.TwrCeny Cena1 ON Cena1.TwC_TwrId = Twr_TwrId and Cena1.TwC_TwCNumer = 5 LEFT OUTER JOIN CDN.TwrCeny Cena2 ON Cena2.TwC_TwrId = Twr_TwrId and Cena2.TwC_TwCNumer = 2 LEFT OUTER JOIN CDN.TwrCeny Cena3 ON Cena3.TwC_TwrId = Twr_TwrId and Cena3.TwC_TwCNumer = 3 LEFT OUTER JOIN CDN.TwrAtrybuty On TwA_TwrId = Twr_TwrId LEFT OUTER JOIN CDN.DefAtrybuty ON TwA_DeAId = DeA_DeAId and DeA_Kod = 'KLAWISZ_SKROT' where LEN(Twr_EAN ) =4 False CREATE TABLE [dbo].[ImportSchematExt]( [Isc_Id] [int] IDENTITY(1,1) NOT NULL, [Isc_Name] [varchar](50) NOT NULL,[Isc_Typ] [int] NOT NULL,[Isc_Serwer] [nvarchar](50) NULL,[Isc_DB] [nvarchar](50) NULL, [Isc_Kierunek] [int] NOT NULL ,[Isc_Rodzaj] [int] NOT NULL, [Isc_User] [nvarchar](50) NULL,[Isc_Passwd] [nvarchar](50) NULL,[Isc_LoginNt] [int] NOT NULL,[Isc_PreQuery] [nvarchar](max) NULL, [Isc_AfterQuery] [nvarchar](max) NULL,[Isc_ImpTyp] [int] NOT NULL,[Isc_ImpRodzaj] [int] NOT NULL,[Isc_ImpDDF] [int] NOT NULL,[Isc_ImpKnt] [int] NOT NULL, [Isc_ImpChangePriceProc] [decimal](15, 4) NOT NULL, [Isc_ImpPrice] [int] NOT NULL,[Isc_ImpMag] [nchar](20) NULL,[Isc_ImpNagQuery] [nvarchar](max) NULL,[Isc_ImpElemQuery] [nvarchar](max) NULL, [Isc_ImpNagCond] [nvarchar](max) NULL, [Isc_ImpElemCond] [nvarchar](max) NULL,[Isc_Agregate] [int] NOT NULL,[Isc_Default] [int] NOT NULL, [Isc_ImpDokCheckIn] [int] NOT NULL,[Isc_FileExt] [varchar](50) NULL,[Isc_FilesSubDir] [nvarchar](150) NULL,[Isc_ImpFpId] [int] NULL, [Isc_Parm1] [varchar](50) NULL, [Isc_Parm2] [varchar](50) NULL, [Isc_Parm3] [varchar](50) NULL, [Isc_Parm4] [varchar](50) NULL CONSTRAINT [PK_ImportSchematExt] PRIMARY KEY CLUSTERED ( [Isc_Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] 0 0 0 0 0 http://api.smsapi.pl/sms.do? False False , 1 2 3 0 1 3 2 0 0 0 0 0 szymekp 6a827533c78cffff6e1bf67a5ea136e6 False False False False ZebraPrinter C:\eykiety\ False False INSERT INTO [dbo].[PolLogs] ([Log_Level],[Log_ObjectId],[Log_Cat],[Log_Msg]) VALUES (@Level,@ObjectId,@Cat,@Msg) select Acc_AccId Id, Acc_Numer Numer, Acc_Nazwa Nazwa, ISNULL( Acc_ParId,0) Nadrzedne from CDN.Konta select Acc_AccId KontoId, Acc_Numer KontoSymbol from CDN.Konta where Acc_OObId=37 and (Acc_Numer LIKE '52%' OR Acc_Numer LIKE '55%' ) and Acc_Poziom = 2 and LEN(Acc_Numer)=6 ORDER BY Acc_Numer select Acc_AccId KontoId, Acc_Numer KontoSymbol from CDN.Konta where Acc_OObId=37 and (Acc_Numer LIKE '50%-20' OR Acc_Numer LIKE '51%-20' ) and Acc_Poziom = 2 and LEN(Acc_Numer)=6 ORDER BY Acc_Numer