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
Hi there, we can modify the sql statement to achieve your expected output. I've been in mssql for 10 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further.
Thanks,
Marlou
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 customer centric IT professional. I would like to discuss more on the projects details. So that we can have better understanding for what needs to done.
It would be great to work with you and hopefully never disappoint you. I am new to this platform but not in the industry.
On time delivery, proper communication and quality work are my top priority.
Thanks
Pramod Verma
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/Node/Laravel/Cake PHP/Codeignitor/ jQuery editors/WordPress Plugins IOS Apps/ Andriod Apps/ Native Apps
Service by us:-
- We will design the project with top most quality and creativity and as per your Standards.
- We are open to revisions in the mock-ups until we achieve your total satisfaction.
- We will provide one months free post delivery assistance and maintenance of the product.
- Progress tracking dedicated communication & support management control of any deviations from the plan fair prices & post delivery maintenance support dedicated quality assurance team.
MY STRENGTHS
* 100% satisfaction assured * 10 Years experienced * Always getting 5 star ratings * Assuring 5* rating services * 100% money back guarantee assured services. * 24 hour turn around time.
ABOUT Me
I am an experienced freelancer from India ,delivering web and mobile solutions for the last 10 years. Before few months I started this freelancer profile and looking to create a professional network and long term client relationships here.
I am ready to start your project Please come on chat to discuss more about your project.
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 rahman
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 if you'd like
I have also just discovered that there is missing conditional elements in the select clause that need to be rectified as well
Regards
Alan Sheppard
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 Connect Databases with .NET Apps and other Plateforms
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 retail.
Throughout my career I've written SQL queries in order to perform complex data analysis on the largest business database in the UK, including time-based status reporting much like the dataset provided.
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 doing DB design.
Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired.
1) Sql Server 2005/2008/2012
2) MYSQL, MS Access
3) Oracle (PL/SQL)
4) SSIS, SSRS , SSAS and Power BI
5) Data analytics using R-Programming and SAS
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]
,[container_id]
,[event_loc1_text]
FROM [CLEANUP_MST].[dbo].[frelance_test1]
WHERE
--after_status_text = 'MISSING' AND before_status_text<>'MISSING' AND
cast(event_ts as Datetime) >= '09/24/2018'
AND cast(event_ts as Datetime) <= '09/26/2018'
Hello,
I have been working as an SQL server developer since 2 years in UnitedHealth Group. And i can fix your Query ASAP. I am okay even if you are not paying the money. All i need is a project to get going in freelancer. Please let me know the server details and i can fix it right away.