Informix SQL Missing Containers
£10-20 GBP
Betalt ved levering
To modify the following sql code.
Please see the attached excel doc for the results of the query.
I need it to Only show after_status_text ='MISSING' If there are no before_status_text ='MISSING' based on the event time.
Each container ID should then be unique
SELECT
wms_appl_event.event_type_desc
, wms_appl_event.event_ts
, wms_appl_event.before_status_text
, wms_appl_event.after_status_text
, wms_appl_event.item_nbr
, wms_appl_event.wms_item_id
, wms_appl_event.after_event_qty
, wms_appl_event.container_id
, wms_appl_event.event_loc1_text
FROM
informix.wms_appl_event wms_appl_event
WHERE
(wms_appl_event.event_ts>(today-3)) AND
(wms_appl_event.event_type_desc='STOCK_STATE') AND
(wms_appl_event.after_status_text='MISSING')
OR
(wms_appl_event.event_ts>(today-3)) AND
(wms_appl_event.event_type_desc='STOCK_STATE') AND
(wms_appl_event.before_status_text='MISSING')
ORDER BY wms_appl_event.event_ts
Projekt ID: #17850090
Om projektet
Tildelt til:
Hi. I am a very experienced web developer with 9+ years of experience working with sql. I can help you with your project.
13 freelancere byder i gennemsnit £19 timen for dette job
Hello Greetings of the day !! Hope you doing good. As per description, SQL query need to modify to get desired output. I have been working similar activity in Business Intelligence projects for 5 years. I am cust Flere
I will provide you complete solution with unique design and development time as per your requirement. Complete end to end solutions, from Development to testing and marketing, we do it all. Full-stack Backbone/Angular/ Flere
Dear sir, I would like to fixed sql issue. I am working with PHP, Codeigniter, Laravel framework, Slim framework, wordpress, mysql, AJAX, JSON, javascript, jQuery, bootstrap, css3 and html5. thanks taiabur ra Flere
Hello A quick look at the SQL WHERE shows a AND/OR logic nesting issue that need to be resolved to correctly apply the boolean logic for the query I can return the corrected SQL syntax in the next couple of hours Flere
I am a database Designer as well as a Database Administrator too. I can Sort this problem out in only one Day Maximum. peak level Expert in Sql and Oracle 11g DBMS. Microsoft Sql Sever Expert. I can Design and Con Flere
I have over 9 years of experience as a database developer for a major financial services provider in London with experience working with clients from a variety of industries, from banking to telecommunications and reta Flere
HI New to this experience, but work on SQL professionally and believe i can get you the desired result quite quickly. Looking forward to hearing back from you. Regards H
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Flere
Sample query. Or the answer. :) SELECT [event_type_desc] ,[event_ts] ,[before_status_text] ,[after_status_text] ,[item_nbr] ,[wms_item_id] ,[after_event_qty] ,[contain Flere