Find Jobs
Hire Freelancers

Customize SQL Query to aggregate dates in range

$30-250 USD

Cancelled
Posted about 7 years ago

$30-250 USD

Paid on delivery
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]
Project ID: 12884167

About the project

7 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 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 in 3 days
4.5 (5 reviews)
3.9
3.9
7 freelancers are bidding on average $96 USD for this job
User Avatar
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 in 3 days
4.8 (10 reviews)
4.3
4.3
User Avatar
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 in 1 day
4.9 (5 reviews)
4.0
4.0
User Avatar
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 in 0 day
5.0 (9 reviews)
3.1
3.1
User Avatar
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 in 1 day
5.0 (2 reviews)
2.8
2.8
User Avatar
A proposal has not yet been provided
$66 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Belmont, United States
0.0
0
Payment method verified
Member since Jan 24, 2017

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.