Find Jobs
Hire Freelancers

MSSQL database query help

$10-30 USD

완료함
게시됨 5년 이상 전

$10-30 USD

제출할때 지불됩니다
The query below is used to select products from a database based on the barcode, or UPC. When I execute this query is SMSS, it works fine and returns 1 result. When I execute on the website using PHP, it returns nothing. I don't see errors and don't have the skills to take this further. I want to know why the query does not work as well as the recommended path to make it work. This is a one time job, but other work will arise in the future. SELECT style FROM TB_SKU_LOOKUPS l, [celerant].[dbo].[TB_SKUS] skus, [celerant].[dbo].[TB_STYLES] styles where skus.STYLE_ID=styles.STYLE_ID and l.SKU_ID = skus.SKU_ID and [login to view URL] like '4643'
프로젝트 ID: 17623269

프로젝트 정보

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

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
I can fix it immediately. You have syntax error that is not compatible with php code. I can start work now
$25 USD 0일에
5.0 (24 건의 리뷰)
4.2
4.2
37 이 프로젝트에 프리랜서들의 평균 입찰은 $26 USD입니다.
사용자 아바타
Hello, I can fix your database issue error as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina
$50 USD 1일에
5.0 (86 건의 리뷰)
7.3
7.3
사용자 아바타
I can help you now.
$30 USD 0일에
4.9 (232 건의 리뷰)
6.9
6.9
사용자 아바타
Dear Hiring Manager, I’ve carefully gone through your job posting on “ MSSQL database query help ” and I am ready to work with you. I want to thank you for the opportunity to earn your business as your provider of web design services. I cannot understate how much we appreciate being able to put this proposal in front of you today. Thanks
$35 USD 1일에
5.0 (141 건의 리뷰)
6.6
6.6
사용자 아바타
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$25 USD 1일에
4.9 (155 건의 리뷰)
6.7
6.7
사용자 아바타
Hi there, I am sql and php expert. I am sure I can help you to check the issue. Please contact me
$30 USD 1일에
5.0 (55 건의 리뷰)
5.7
5.7
사용자 아바타
Hello, I have checked project requirements and can work on this project. It will be delivered with quality. Thanks.
$20 USD 1일에
4.8 (49 건의 리뷰)
6.0
6.0
사용자 아바타
INTRODUCTION I can re-write your query using JOINS. I have 4+ years’ experience with database architecture and strategy; exhibiting excellent technical skills, and a keen sense of innovation. I am skilled in database programming and development with experience in designing, developing and understanding analytics. I am also skilled in database administration, building reports and customized dashboards and the ability to turn ideas into functional solutions. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/website-design/database-design-link-site/ • https://www.freelancer.com/jobs/project-15444898/ • https://www.freelancer.com/projects/mysql/review-database-model-for-survey/ • https://www.freelancer.com/projects/sql/human-resources-database-creation/
$30 USD 1일에
4.8 (30 건의 리뷰)
6.1
6.1
사용자 아바타
Very simple job just let me know few things. Which version of php you are using, is it mysql or mysqli in case you are not able to find that no worries, will figure it out myself. In php 7 there is different ways of wring the query than php5 and for connectivity to db mysql and mysqli works differently Please provide details and will be sorted out within one hour or less. Thanks
$20 USD 1일에
4.9 (61 건의 리뷰)
5.6
5.6
사용자 아바타
Sr. Software Professional having 9.0+ years experience. ***************************************************** Technology : Web Application Windows/Desktop Application ************************* Database Language : MSSQL, Oracle, MySQL, Microsoft Access
$55 USD 1일에
5.0 (18 건의 리뷰)
4.3
4.3
사용자 아바타
HI, i can solve the issue of Mysql and PHP. kindly send me mysql file so i can fix it Please send me a message so that we can discuss more.
$25 USD 1일에
4.9 (10 건의 리뷰)
3.9
3.9
사용자 아바타
Hello, my name is Alejandro Bravo and I am a professional with more than 15 years of experience in Information Technology. As Sysadmin, I have extensive practical knowledge of Windows Server, Active Directory, VMWare, SQL Server, MySQL, Azure, AWS, VPS, cPanel, Webmin, Wordpress, as well as certifications in Linux & Oracle. By reading on your issue I think that it is very likely that there's something wrong with your connection string, if we could just share scree it should be quick Good luck! Cheers Alex
$25 USD 1일에
5.0 (8 건의 리뷰)
4.0
4.0
사용자 아바타
I am working as a senior web developer for 5 years. My key points: -Full time work -Responsive communicate -Clean coding skills I can provide good result to you within your timeframe. When you are free, please get in touch. I want to discuss about your project in more detail. Thank you for reading. Best Regards.
$25 USD 1일에
5.0 (9 건의 리뷰)
3.7
3.7
사용자 아바타
Dear Hiring Manage, I am have 5+ year of experience in web development. I read your requirements. I can do it. Can we discuss about project. thanks
$20 USD 1일에
4.9 (15 건의 리뷰)
3.6
3.6
사용자 아바타
Thanks for posting job, I have read your description this is possibility to deliverables in proper manner Domaxy Infosoft Pvt. Ltd. deliver quality work with Creativity and incredibility. We are NCR based organization and we ensure that your satisfaction is priority of us. We are providing service more than 5 years as Web development and mobile development company, we are having more then 100+ Client across world with 400 + project delivered We Provide: • Mobile app & Website design and development • Custom solution for your requirement • Exclusive UI/UX design • Web Application and on demand services Why US • 100% satisfaction with delivered work • Timely deliveries and deployment • Cost effective and quality code as per W3C standard • Free Support after deployment • Proactive Approach to identify security of code We want to service you for long-term, Please reply me so we can move ahead
$25 USD 1일에
4.1 (11 건의 리뷰)
4.3
4.3
사용자 아바타
Hi. I suppose that you have this result because "TB_SKU_LOOKUPS" table is not the same database as other tables. Regards, Andrey.
$25 USD 10일에
5.0 (13 건의 리뷰)
3.5
3.5
사용자 아바타
Hello dear sir. I have great experience in software development and I can do this job for you within your expectation timing. Please allow me to do this job for you.
$25 USD 1일에
4.6 (3 건의 리뷰)
2.2
2.2
사용자 아바타
Could be anything so I estimated this to be 10 days but it could take as little as an hour or as long as a week?
$15 USD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
We have excellent experience in mssql and php can trace into your issue, ready to reach best offer for you if you accept Tobe our first client, we are looking for long term cooperation, waiting to hear from you many thanks
$30 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
hello i have 5+ yr exp in web and mobile development let's discuss and have good work done thank you
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
* Extensive experience with SQL Server and T-SQL in constructing triggers, Tables, User Functions, Views, Indexes, CTE. * Expert in using SQL Server Agent to Schedule and Monitor Jobs.
$15 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
Portland, United States
5.0
10
결제 수단 확인
3월 15, 2018부터 회원입니다

고객 확인

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