Torna al Thread

SELECT dbo.Vp.[Sap Product code], dbo.Vp.[Sale date], dbo.Vp.[Sale quantity UMB] SUM dbo.Vp.Sale quantity UMB FROM dbo.Vp INNER JOIN dbo.somma ON Vp.Sap Product code=somma.Sap Product code WHERE [Sap Product code] IN ('16662','16661','16663','16664','17189','17190','17191','17192','17802','17803','17804','17805') GROUP BY [Sap Product code], [Sale date], [Sale quantity UMB] HAVING ([Sale date] LIKE '= 102009%') ORDER BY [Sale date]
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5