Find Jobs
Hire Freelancers

Informix SQL Missing Containers

£10-20 GBP

Completed
Posted over 5 years ago

£10-20 GBP

Paid on delivery
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
Project ID: 17850090

About the project

13 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi. I am a very experienced web developer with 9+ years of experience working with sql. I can help you with your project.
£15 GBP in 1 day
5.0 (15 reviews)
4.7
4.7
13 freelancers are bidding on average £19 GBP for this job
User Avatar
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
£23 GBP in 1 day
5.0 (3 reviews)
3.0
3.0
User Avatar
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
£13 GBP in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
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.
£33 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
£21 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
£20 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
£25 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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'
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Le193ej, United Kingdom
5.0
7
Payment method verified
Member since Dec 17, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.