Find Jobs
Hire Freelancers

Customize SQL Query to aggregate dates in range

$30-250 USD

Anulowano
Opublikowano około 7 lat temu

$30-250 USD

Płatne przy odbiorze
I have a data query that gets me inventory on hand by date: e.g. For Date 2016-01-03 it would get: Part Qty SKU1 10 SKU2 5 I would like it customized to get quantity on hand by date, e.g.: Part 2016-01-01 2016-01-02 2016-01-03 SKU1 8 7 10 SKU2 0 6 5 Database it is drawing from is FirebirdSQL. The existing query is: SELECT [login to view URL] AS partnumber, [login to view URL] AS locationgroupname, COALESCE([login to view URL], 0) AS qtyonhand, [login to view URL] AS partdescription, [login to view URL] AS vendor, COALESCE([login to view URL], 0) AS avgcost, COALESCE([login to view URL], 0) AS stdcost, COALESCE((SELECT FIRST(1) ([login to view URL] / [login to view URL]) AS cost FROM costlayer WHERE [login to view URL] = [login to view URL] AND [login to view URL] = 10 ORDER BY [login to view URL] ASC),0) AS FIFOcost, COALESCE((SELECT FIRST(1) ([login to view URL] / [login to view URL]) AS cost FROM costlayer WHERE [login to view URL] = [login to view URL] AND [login to view URL] = 10 ORDER BY [login to view URL] DESC),0) AS LIFOcost, [login to view URL] AS uom, [login to view URL] AS company FROM part JOIN (SELECT max([login to view URL]) AS logid, [login to view URL] AS logpartid, [login to view URL] AS loglocationgroupid FROM inventorylog WHERE [login to view URL] <= '2017-01-01' AND [login to view URL] IN (1,10,15,20,30,40,50,60,64,65,67,68,72) GROUP BY [login to view URL], [login to view URL]) AS maxlogdate ON [login to view URL] = [login to view URL] JOIN inventorylog ON [login to view URL] = [login to view URL] JOIN locationgroup ON [login to view URL] = [login to view URL] LEFT JOIN vendorparts ON ([login to view URL] = [login to view URL] AND [login to view URL] = 1) LEFT JOIN vendor ON [login to view URL] = [login to view URL] LEFT JOIN partcost ON [login to view URL] = [login to view URL] LEFT JOIN uom ON [login to view URL] = [login to view URL] JOIN company ON [login to view URL] = 1 WHERE [login to view URL] = 10 AND [login to view URL] IN (1,10,15,20,30,40,50,60,64,65,67,68,72) ORDER BY [login to view URL], [login to view URL]
Identyfikator projektu: 12884167

Informację o projekcie

7 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Hi sir I am Hasan Jack and I have have been doing php development since last 5 years and because of my relevant skills and experience I really find myself best fit for this job. Looking forward to hear from you. Regards, Hasan Jack
$50 USD w 3 dni
4,5 (5 opinii)
3,9
3,9
7 freelancerzy składają oferty o średniej wysokości $96 USD dla tej pracy
Awatar Użytkownika
Experienced programmer with more than 10 years of development experience here. I am expert in query manipulation, cursors, sub query and joins. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success. This is a tentative bid, and may change post understanding exact scope.
$100 USD w 3 dni
4,8 (10 opinii)
4,3
4,3
Awatar Użytkownika
I'm Computer Scientist and ready to deal with various projects as Java projects, C#/C++, SignalR based applications, MySQL, MS SQL server, Database schema, Image processing, Matlab, MS visual studio, Eclipse and Aptana studio for python, Good in UML diagrams(Use Case diagram, Class diagram, Activity diagram, ER diagrams) and expert in Software Architecture(Client Server Arch.,Black board arch., Rule based arch., Event driven arch., Publish subscriber arch., Rest Arch) and MVC pattern. I make sure delivery of project on time and exactly according to requirements.
$66 USD w 1 dzień
4,9 (5 opinii)
4,0
4,0
Awatar Użytkownika
Please review my profile. I have 7.2 years experience in SQL and 4.4 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe: jikenjd
$49 USD w 0 dzień
5,0 (9 opinii)
3,1
3,1
Awatar Użytkownika
Dear, I have experience 10 years in sql server database development and web development using ASP.net i am ready to do this task now
$30 USD w 1 dzień
5,0 (2 opinii)
2,8
2,8
Awatar Użytkownika
A proposal has not yet been provided
$66 USD w 5 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Belmont, United States
0,0
0
Zweryfikowana metoda płatności
Członek od sty 24, 2017

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.