Find Jobs
Hire Freelancers

fix a ms sql query

€8-30 EUR

Completed
Posted over 6 years ago

€8-30 EUR

Paid on delivery
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');
Project ID: 15399742

About the project

3 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have good proficiency in sql server. I would like to make your third query work. ............................
€9 EUR in 1 day
5.0 (17 reviews)
4.5
4.5
3 freelancers are bidding on average €15 EUR for this job
User Avatar
Are you online now to work together on the issue? Please ping if you are online. Can work now with you.
€14 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Villanova Mondovì, Italy
4.9
90
Payment method verified
Member since Jun 25, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.