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]
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
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.
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.
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