Torna al Thread

select DISTINCT P.AUFNR as BATCH_ORDER, B.MATNR as AQST, SUBSTRING (P.ZSDMODCODE, 4, 1) as BATCH_GROUP, SUBSTRING (P.ZSDMODCODE, 11, 1) as ROTATION, P.MATNR as SAUER_CODE, B.POSNR as ID_BOM, B2.POSNR as ID2_BOM, SUBSTRING (B2.MAKTX, 22, 29) as ALTERNATIVE_CODE, P.GAMNG as QUANTITY, LEFT (P.ZSDMODCODE,16) as IMMC, RIGHT (P.ZSDMODCODE,16) as IIMMC, UPPER (REPLACE (CONVERT (Varchar, GETDATE(), 106), ' ', '/')) as MARKING_DATE from dbo.PRODORDER as P INNER JOIN dbo.BOM as B ON P.AUFNR = B.AUFNR INNER JOIN dbo.BOM as B2 ON P.AUFNR = B2.AUFNR where P.AUFNR in (5947133, 5954096, 5959053, 5960458, 5966239) and (B.POSNR = '9999' and B2.POSNR = '9500')
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5