SQL Code/view creation
- or -
Post a project like this1625
£275(approx. $344)
- Posted:
- Proposals: 14
- Remote
- #2595030
- OPPORTUNITY
- Awarded
Full Stack Web Developer/ Designer / Mobile Apps / Wordpress / Magento / Shopify / Opencart / BigCommerce / APIs / PHP / Python /
Bay Minette
React.js♥WORDPRESS THEME♥SHOPIFY♥WP theme♥PSD 2 XHTML,HTML5( Bootstrap, Sass, Scss )♥ASP.NET (C#,DNN)♥PHP♥SEO♥SEM
Jaipur
Wordpress Developer *Full Stack Web Developer * Shopify Developer*PHP* REACT JS
Islamabad
Azure | PowerBI | SQL | SSIS | SSAS | Tableau | Javascript | Jquery | MVC .Net Core | EF Core | .Net Core API | ASP.Net |
Ranchi
6638412498161189697155271520583332419237247740225032812616246274230727673113155621
Description
Experience Level: Expert
I have a table with the following headings which records stock movements in and out which is called dbo.Stock_Record
ID Part_ID Qty_Required Date_Destocked Action Deleted
The Action field can be either “Delivery”, “Destock” or “Adjustment”, the deleted field is true or false, the date_destocked is a datetime field.
I have a second table which records stock counts at the month end called dbo.Stock_Count. The count_date is always the last day of each month
ID Part_ID Count_Date Stock_Count
I need a sql view which will calculate the stock total on the last day of each month as a sum of the Qty_required field called EOM_Stock. I then need this in a pivot table with the following totals as at the last day of each month, combining the data from the two tables. If there is no data recorded in a month then it needs to show the same EOM_Stock as the previous month and zero for the other fields. If there is no stock_count data then it needs to show zero
Part_ID Month_End_Date Delivery Destock Adjustment EOM_Stock Stock_Count
ID Part_ID Qty_Required Date_Destocked Action Deleted
The Action field can be either “Delivery”, “Destock” or “Adjustment”, the deleted field is true or false, the date_destocked is a datetime field.
I have a second table which records stock counts at the month end called dbo.Stock_Count. The count_date is always the last day of each month
ID Part_ID Count_Date Stock_Count
I need a sql view which will calculate the stock total on the last day of each month as a sum of the Qty_required field called EOM_Stock. I then need this in a pivot table with the following totals as at the last day of each month, combining the data from the two tables. If there is no data recorded in a month then it needs to show the same EOM_Stock as the previous month and zero for the other fields. If there is no stock_count data then it needs to show zero
Part_ID Month_End_Date Delivery Destock Adjustment EOM_Stock Stock_Count
Charlie S.
100% (1)Projects Completed
3
Freelancers worked with
3
Projects awarded
50%
Last project
16 Feb 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies