Find Jobs
Hire Freelancers

SQL - Fix Outer Join Issue

$10-30 USD

완료함
게시됨 4년 이상 전

$10-30 USD

제출할때 지불됩니다
We have a script that is not returning the correct values per the following requirements (refer to attached files for reference). #1. Records should be displayed for all records appearing in sales_order_details that match records in pick_history (sub query). #2. Records in pick_history should also be matched against shipment_details. If no match exists in shipment_details, all records from #1 should still display and records from #2 should display 0 (zero). #1 is working fine. However, when we add a left outer join for shipment_details in #2, we get incorrect records returned. We need someone to fix the query to display records correctly as mentioned above. See attached database and script files for more information.
프로젝트 ID: 22802908

프로젝트 정보

35 제안서
원격근무 프로젝트
활동 중 4년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi! I'll conduct some tests and will get back with any queries I might have or a ready solution. Regards, Dobri EDIT 2019-12-11 02:48 GMT+2: I have the fixed query ready.
$25 USD 1일에
4.9 (76 건의 리뷰)
5.4
5.4
35 이 프로젝트에 프리랜서들의 평균 입찰은 $26 USD입니다.
사용자 아바타
Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$30 USD 1일에
4.8 (61 건의 리뷰)
5.8
5.8
사용자 아바타
Proposal - You can expect any kind of work on SQL from me. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$30 USD 1일에
5.0 (27 건의 리뷰)
4.9
4.9
사용자 아바타
Hello! I can deal with this as well. Just ping me if you're interested after you finish testing my other work. Thanks!
$30 USD 1일에
5.0 (18 건의 리뷰)
4.8
4.8
사용자 아바타
Hello! I am a MySQL expert. I have checked your project description. If you hire me, I am gonna do my best. I guarantee the perfect result. I will be right here waiting for you. Best regards.
$20 USD 1일에
5.0 (8 건의 리뷰)
4.6
4.6
사용자 아바타
Hello. I can help you. I have more than 10 years of experience in database administration and querying over MySQL and SQL Server. Thanks, regards
$30 USD 1일에
5.0 (7 건의 리뷰)
4.5
4.5
사용자 아바타
I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
$30 USD 1일에
5.0 (23 건의 리뷰)
4.2
4.2
사용자 아바타
hi ,i have around 10 years of experience in SQL developement and working as team lead.I can surely help you in this scenario
$30 USD 1일에
5.0 (20 건의 리뷰)
4.4
4.4
사용자 아바타
Hi i am expertise in sql queries if u are interested ping me i wil lsolve this quickly tell me ur bid.
$35 USD 1일에
4.8 (15 건의 리뷰)
4.4
4.4
사용자 아바타
Dear sir, I am senior software engineer in sri lanka with skill of PHP, Laravel, Asp.net , C#, I would like to complete your project as your needs. Please contact me for more details Thanks
$25 USD 1일에
5.0 (11 건의 리뷰)
3.9
3.9
사용자 아바타
I am good in sql stuff along with automation and development, please let me know if you are good to award this project to me
$30 USD 1일에
5.0 (7 건의 리뷰)
4.0
4.0
사용자 아바타
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 10 years experience in MS SQL Server and 7.3 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd
$30 USD 1일에
5.0 (22 건의 리뷰)
4.0
4.0
사용자 아바타
Sir, I read through the job details of your project, I check your attached files and am I am absolutely sure that I can do this project very well. I am a MySQL expert databases and I can correct the queries you need. I look forward to working with you. Thanks for reading. Best Regards.
$30 USD 3일에
5.0 (11 건의 리뷰)
3.3
3.3
사용자 아바타
I am expert in DB Design and implementation. I have good expertise in SQL and can do the task as per your requirements.
$30 USD 2일에
4.6 (10 건의 리뷰)
3.3
3.3
사용자 아바타
Hi I have reviewed your project for a while. I think I can handle your project professionally as a Web and SQL developer with 10 years of experience with the full software development lifecycle. I've excelled with legacy source code, crushing bugs and implementing new features regardless of the state of the codebase. Shall we discuss your project? Thank you.
$30 USD 1일에
5.0 (3 건의 리뷰)
2.6
2.6
사용자 아바타
Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in sql. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
$20 USD 1일에
5.0 (4 건의 리뷰)
2.2
2.2
사용자 아바타
Dear Client. I have good skill in sql(MySql) Hi, I have read & understood requirements for your blog. I want to work for you! I would be grateful to hear from you. Thanks.
$20 USD 1일에
5.0 (2 건의 리뷰)
1.5
1.5
사용자 아바타
Hello, How are you? I'm very happy to have an opportunity placing my bid on your job posting. In the case of # 2, if there is a record on either side that does not match, the result will be returned. If no match exists in shipment_details, #1 sub query should still display and # sub query should display zero. This is easy. I think you will hire me and I have no problem about that. Thanks.
$30 USD 1일에
5.0 (1 건의 리뷰)
0.6
0.6
사용자 아바타
I have a 15 years of experience on building Oracle database applications, I am a very good in writing Oracle SQL and PL/SQL codes. Contact me if you want your project accomplished very well. This is my first task, i have a motivation to complete your task.
$35 USD 1일에
5.0 (1 건의 리뷰)
0.6
0.6
사용자 아바타
Dear sir. I see your post project and I'm very interested in your post project. I have skills that you are looking for. I graduated from college and worked as a researcher.I started developing the web a while ago. My major was in the program area when university, so maybe it will help you. And not long ago I returned to Russia, the days that I begined for a freelancer to work are not enough. I developed projects that is almost similar to your project. I returned to Russia not long ago from foreign country(England),so I have no time to work in freelancer.com So I have nothing reviews,but I can it. I think that if you hire me you can get full success. If you agree with me, you may chart me and I'll abailability beginning soon. Thank you for consideration. Presentation Specialist.
$20 USD 7일에
0.0 (0 건의 리뷰)
0.6
0.6
사용자 아바타
Senior developer you can search me on LinkedIn. I have sql knowledge and experience and work on projects based on plsql MySQL Cassandra etc.
$30 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (CANADA)
huntley, Canada
5.0
124
결제 수단 확인
8월 24, 2005부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.