I need a query for get some informations from Ms Sql, but for privacy requirements, i can't give you access to datatabase. However i can give you two queries that working right where you can get the table names required
------
Select MGGiacDisp.Cd_AR,[login to view URL],cast(format(Sum([login to view URL]), \'N\', \'it-it\') as varchar(20)) AS TotaleQuantita From MGDisp('+AnnoCorrente+') MGGiacDisp Inner Join AR On MGGiacDisp.Cd_AR = AR.Cd_AR Inner Join ARARMisura On AR.Cd_AR = ARARMisura.Cd_AR And [login to view URL] = 1 WHERE MGGiacDisp.Cd_MG IN (\'00020\',\'0001\') GROUP BY MGGiacDisp.Cd_AR,[login to view URL] ORDER BY MGGiacDisp.Cd_AR
------
SELECT [dbo].[AR].[Cd_AR], [dbo].[AR].[Descrizione], cast(format([TabGiacenza].[Quantita], \'N\', \'it-it\') as varchar(20)), [ARLotto].[DataScadenza], [TabGiacenza].[Cd_ARLotto], [MG].[Descrizione] FROM [dbo].[MGDispEx] (2017) AS TabGiacenza INNER JOIN [dbo].[AR] ON [TabGiacenza].[Cd_AR] = [dbo].[AR].[Cd_AR] LEFT JOIN ARLotto ON [TabGiacenza].[Cd_ARLotto] = [ARLotto].[Cd_ARLotto] AND [TabGiacenza].[Cd_AR] = [ARLotto].[Cd_AR] INNER JOIN [dbo].[MG] ON [TabGiacenza].[Cd_MG] = [dbo].[MG].[CD_MG]
The goal is take the first one query and add this condition
. Where TotaleQuantita < 0
and Select also
. MGGiacDisp.Cd_MG
I done this query but it doesnt' working
SELECT MGGiacDisp.Cd_AR, [login to view URL], MGGiacDisp.Cd_MG, cast(format(Sum([login to view URL]), \'N\', \'it-it\') AS varchar(20)) AS TotaleQuantita FROM MGDisp('+AnnoCorrente+') MGGiacDisp INNER JOIN AR ON MGGiacDisp.Cd_AR = AR.Cd_AR INNER JOIN ARARMisura On AR.Cd_AR = ARARMisura.Cd_AR AND [login to view URL] = 1 WHERE MGGiacDisp.Cd_MG IN (\'00020\',\'0001\') AND TotaleQuantita < 0 GROUP BY MGGiacDisp.Cd_AR,[login to view URL] ORDER BY MGGiacDisp.Cd_AR');