sql - Adding Total Sales -

-

I'm having trouble getting the total number of items sold. The script below shows me total sales but their short does not. I got to tell this, but it was listing duplicate invoices so I "separate" before the invoice. I do not know where I'm messing with. Note that I do not have any previous SQL training, I have only got it from reading the questions of other readers. Please help. thank you in advanced. 

  select sh.invoice_no, sr.item_id, sr.item_desc, sr.last_sale, sr.SQ, sr.DQ, sr.AQ, sr.VQ, sr pq, sr.iQOH , Sr.avg_MAC, si.cost, sr.PT, item, SUM (sh.qty_shipped) as QTY_Shipped from iml_view_item_stock_review_nh to si.item_id sr include sr.item_id = si.item_id interi as C Include as p21_view_inventory_supplier as sh on Sr1item_id = sh.item_id p21_sales_history_view where (sr.item_id 'IEI%') and (sr.PT = 'R') and (sh.invoice_date & gt; Convert (DATETIME, ' 2013-10-17 00:00:00 ', 102)) GROUP by sr.item_id, sr.item_desc, sr.last_sale, sr.SQ, sr.DQ, sr.AQ, sr.VQ, sr.PQ, sr .iQOH, sr Avg_MAC, CIOST, SRPTT, CIITM_I D, SAREVICE_NO

Below is a sample of data. I have left some other columns. I hope it will help.

| Invoice_no Item_ID | QTY_Shipped | | | ----------------------------------------- | | 1000616 | IEEE 0803000F. 4 | | 1001289 | IEEE 0803000F. 2 | | 1018242 | IEEE 0803000F. 2 | | 1001224 | IEI212I | 2 | | 1002265 | IEI212I | 2 | | 1003547 | IEI212I | 2 |

Expected output is something like this: 

  | Item_ID | QTY_Shipped | | | -------------- | -------------- | | IEEE 0803000F. 8 | | IEI212I | 6 |

Sorry if I do not have much knowledge, my company is sending me to be trained and certified in January and soon I will help others. Thanks in advance.

It was found that my query was right at the right time I was just shocked by the data 

  select sr.item_id, sr.item_desc, sr.last_sale, sr.SQ, sr.DQ, sr.AQ, sr.VQ, sr.PQ, sr.iQOH, sr.avg_MAC, CIOOST, SR INV JOIN P 21_view_ as SRPT, CIITM_ID Asim (SAP), SUM (SATIPPP), as an IML_view_item_stock_review_nh as inventory_planer SI.itm_id = citm_id Join Inner P21_sales_ Shr.item_id = sh.item_id where history_view is where (sr.item_id 'IEI%') and (sr.PT = 'R') and (sh.invoice_date & gt; DATEADD (year, -1, GETDATE) ) GROUP by sr.item_id, sr.item_desc, sr.last_sale, sr.SQ, sr.DQ, sr.AQ, sr.VQ, sr.PQ, sr.iQOH, sr.avg_MAC, si.cost, sr.PT , Si.item_id

Comments

Post a Comment

Popular posts from this blog

winforms - C# Form - Property Change -

-
I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
Read more

javascript - amcharts makechart not working -

-
I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
Read more

java - Algorithm negotiation fail SSH in Jenkins -

-
I am trying to do SSH on the local server from Jenkins, but the following error has been thrown: [SSH] Exception: Algorithm negotiation fail com.jcraft.jsch.JSchException: algorithm talk com.jcraft.jsch.Session.receive_kexinit (Session.javaatar20) at com.jcraft.jsch.Session.connect (Sesson at com.jcraft.jsch.Session.connect (Session.java:150) at org.jvnet.hudson.plugins.SSHSite.createSession (SSHSite.java:141) on failed failed org.jvnet.hudson.plugins. java: 286) .SSHS on org.jvnet.hudson.plugins.SSHBuildWrapper.executePreBuildScript (SSHBuildWrapper.java:75) on Org.jvnet.hudson.plugins.SSHBuildWrapper.setUp (SSHBuildWrapper.java59) ite.executeCommand (SSHSite.java151) on hudson.model.Build $ BuildExecution.doRun hudson.model.AbstractBuild $ AbstractBuildExecution.run (AbstractBuild.java:533) to (Build.java:154) hudson.model.Run.execute ( Run.java:1754) in ended .model.FreeStyleBuild.run (FreeStyl hudson.model.ResourceController.execute (ResourceController.java:89) on hudson.mod...
Read more