Torna al Thread

SELECT [CATEGORIE MERCEOLOGICHE].[cod categoria] AS Expr1, Sum(TabellaMovMag.QtMov), sum(([ARTICOLI MAGAZZINO].PrezzoIvato-TabellaMovMag.PrAq)), sum(TabellaMovMag.PrAq) as Uscite, sum([ARTICOLI MAGAZZINO].PrezzoIvato) as Entrate FROM [ARTICOLI MAGAZZINO] INNER JOIN TabellaMovMag ON [ARTICOLI MAGAZZINO].[cod articolo] = TabellaMovMag.CodArt INNER JOIN [CATEGORIE MERCEOLOGICHE] ON [ARTICOLI MAGAZZINO].[cod categoria] = [CATEGORIE MERCEOLOGICHE].[cod categoria] WHERE ( (TabellaMovMag.CausaleMov = 1) OR (TabellaMovMag.CausaleMov = 2) OR (TabellaMovMag.CausaleMov = 4) OR (TabellaMovMag.CausaleMov = 9)) AND [CATEGORIE MERCEOLOGICHE].[cod categoria]=@cod AND TabellaMovMag.DataMov<=@dataFine AND TabellaMovMag.DataMov>=@dataInizio GROUP BY [CATEGORIE MERCEOLOGICHE].[cod categoria]
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5