Resolve SQL Stored Procedure Issue - 28/03/2024 01:19 EDT

$15-25 USD / hour

Kapalı

İlan edilme:

yaklaşık 2 ay önce

$15-25 USD / hour

Please I have now had a number of sql developers who just disappear, cannot do teh job right now and start BS about php work. Stay away if you do not have time and understanding of how to work with sql. Timeline: Start immediately Deliver within the day. Issue: I describe the below issue as one of the issies There is a second issue that has a similar problem but it cannot be explained here due to the cinfidentiality NDA: my code is private and paid for. You sign my NDA which is a standard nda. It can be signed in Adobe reader which is free. Type in, save and send back. Very easy. Freelancer has approved this nda many times since they cannot force anyone to use their nda. This is a legal thing where the country law force them to approve my nda. The country law is always above any company and person. Description: I'm in need of a an stored procedure expert in SQL expert who can dissect and troubleshoot a stored procedure issue within my database. Specifically, it's not fetching the correct number of products and I require assistance to fix this. Table The table holds 4 areas Each area has 14 products with different product values. Stored procedure The stored procedure give these values. 1. Area 1 gives 11 products only 2. Area 2 gives 12 products only 3. Area 3 gives 12 products only 4. Area 4 gives 12 products only The input parameters are exactly the same for all areas except for one parameter. Correct resilts It should always be 14 products delivered whatever the parameters are. - **Stored Procedure Function**: It's primarily used for fetching products. - **Criteria to Address**: The problem lies in listing the correct products from the database. The ideal freelancer should be capable of analyzing and modifying existing criteria to ensure apt product delivery. - **Expected Output**: The resultant list after the procedure executes must be in SQL response format. An understanding of how to deliver results in this format is essential. This project requires strong stored procedure expert with SQL skills in MySQL database engine, and a knack for identifying and rectifying errors within stored procedures. Experience in database administration and debugging would be beneficial.

MySQL

SQL

Proje No: 37929427

Proje hakkında

105 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 18 gün önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

105 freelancer bu proje için ortalama $21 USD/ saat teklif veriyor

@OutsourceMan

Harnessing over a decade and a half of my invaluable experience, I, Raman of CnELIndia, represent the amalgamation of unrivaled technical expertise and commendable problem-solving skills. Derived from my mastery in PHP and WordPress development, my knack for optimization and debugging will play a pivotal role in tackling your stored procedure conundrum effectively. Having catered to an extensive client base with diverse requirements, I comprehend the implications of time constraints and ensure prompt, yet impeccable results. My objective is not just to meet expectations but to exceed them altogether. In light of your confidentiality concerns, let me assure you that I thoroughly understand the gravity of data privacy and willingly comply with appropriate NDAs. With profound competency in MySQL database management, I'm adept at dissecting intricate issues like yours and providing robust resolutions. Precise product delivery is an absolute priority and I have a strong understanding of SQL response format, which will decipher into accurate outcomes for you. Trust in my top-rated expertise to leave no stone unturned in ensuring optimal functioning within your database. Choose me for your project - I’ll ensure hassle-free functionality

$20 USD 40 gün içinde

4,9

(277 değerlendirme)

8,3

@WhizPool

I previously did place a bid on this, and placing it again. All i need is (after NDA) - Your SQL schema with data. - Your current stored procedure(optional) And let me do my magic. I can deliver within a day. I am not talking about PHP etc, because what use is of a backend language when i am calling a stored procedure. To verify, i need the current procedure output and the desired output. Let's get to work. Thanks, Zeeshan

$30 USD 8 gün içinde

5,0

(16 değerlendirme)

7,5

@talhaamin

Hello, Yes i have seen your project posted at least two times before ... I know that you are looking for someone to fix the stored procedure. I have lots of experience in working with stored procedures and have good knowledge of using cursors, in memory tables etc to make complex queries work. I do not have any problem in signing the NDA.. I know your problem statement would like to have a look at the table structure and stored procedure code. Looking forward to discuss further. Thanks, Talha Amin

$20 USD 40 gün içinde

5,0

(38 değerlendirme)

7,5

@cmitexperts

Hi there! Did go through your job description and glad to share that I have experience in working with PHP and MySQL development platform. I have more than ten years of industry experience and have been the part of diverse industry verticals. I also have expertise with ReactJs,VueJs, Laravel, Magento, WordPress, PHP, API's development & Integration and CodeIgnitor along with XD and Figma. So can help you with the design as well. Looking forward to your response.

$25 USD 40 gün içinde

5,0

(90 değerlendirme)

6,9

@sagarwal3005

Hello i csn start immediately and help in fixing the stored procedure for your script.i have 13+ years of experience in SQL stor3d procedures. I can sign the NDA and send it back. Please drop a message

$25 USD 40 gün içinde

5,0

(70 değerlendirme)

6,6

@Rekhathakur

Hello, I can start immediately. I have 10+ years of experience and I ensure you I can complete the project within budget and timeline. I have few questions about the requirement. Can we discuss this over chat? Looking forward to hearing from you soon. Best regards, Rekha

$25 USD 40 gün içinde

5,0

(21 değerlendirme)

6,7

@creativewebideas

Hello, I'm a SQL specialist with extensive experience in writing and debugging stored procedures. I understand you're facing issues with your stored procedure not fetching the correct number of products. My approach: 1. Review the procedure code to identify any conditional logic or joins that may be causing the incorrect counts. 2. Validate the input parameters and their usage within the procedure to ensure consistency across all areas. 3. Test the modified procedure thoroughly to confirm it returns 14 products for each area regardless of the parameters. I am ready to deliver a quick and accurate resolution to your stored procedure issue, ensuring consistent and correct output for your product data. Best regards, Muzz

$25 USD 40 gün içinde

5,0

(27 değerlendirme)

6,8

@AwaisChaudhry

Hi Good afternoon , I have read the brief details on your job listing . I see you have been looking for someone experienced with SQL and MySQL. Its been 8 years since I have been working on freelancer.com, I have 9 years of experience doing similar jobs. I would request you to check my profile and review projects, feedbacks of projects related to those skills. Questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements in chat and let me review and get back with queries. 2. Do you currently have anything done or this job has to be done from scratch? 3. What is the timeline to get this job done? 4. Are you open to use 3rd party APIS for it even if they are paid? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Please initiate the chat so we could discuss it in detail and we will continue from there. Thanks! Awais

$25 USD 31 gün içinde

5,0

(26 değerlendirme)

6,9

@mascotindia123

★★★★★★ START NOW ★★★★★★ Message me so we talk in detail. Yes, I can Resolve SQL Stored Procedure Issue perfectly !! I placed a bid after checking your requirement if you want you can ask me any questions regarding your requirement. I'm interested to work on your project. And don't worry about work. first, check my work if you are happy Then pay me. Please let me know if you require any detailed information. Waiting for your reply. I hope you respond to me. Thanks

$20 USD 40 gün içinde

4,9

(92 değerlendirme)

6,8

@tutulsoft

I am truly Store Procedure Expert. working 25 years with database. i read your full description , and surely confidential and you get me more profession about this context. Also your SP job i can do very confidently with your expected result as outcome

$20 USD 40 gün içinde

5,0

(52 değerlendirme)

6,1

@Truonggiang86

Hello there, I've read your problem about your stored procedure not producing the correct 14 products per area where it should be. I think in this case there might have some problem within the joining statement inside the stored procedure so that it will produce less than normal. I think within more than 13 years working with SQL I can troubleshoot and fix this for you. I can start immediately so let's discuss. Waiting for your response if interested. Thank you!!!

$30 USD 40 gün içinde

5,0

(58 değerlendirme)

6,3

@giaphung2k1

Hiya As a freelancer, I understand how frustrating it can be to work with unreliable SQL developers who do not deliver on their promises. However, I am here to help find a solution for your current SQL stored procedure issue. Firstly, let's assess the current situation and the steps that led to this issue. This will help us identify the root cause and avoid similar problems in the future. Next, let's review the existing stored procedure and the desired outcome. We can then identify any errors or missing components that are causing the issue and make the necessary changes. Additionally, I can collaborate closely with you to ensure that the required data is accessible and properly organized. This will prevent any data-related errors and ensure the smooth functioning of the stored procedure. Furthermore, I will provide regular updates and maintain transparent communication throughout the project. This way, you can track the progress and ensure that the issue is being resolved efficiently. In the case of any unexpected setbacks or delays, I will communicate them to you promptly and provide alternative solutions to keep the project on track. Once the issue is resolved, I can also provide you with recommendations on how to optimize and improve the stored procedure for better performance in the future. Lastly, I assure you that I am committed to delivering quality work within the given timeframe and budget. You can trust me to complete the project successfully and ensure that you are satisfied with the outcome. Thank you for considering my proposal. I am confident that together, we can find a suitable solution for your SQL stored procedure issue. Best regards, Giáp Văn Hưng

$25 USD 7 gün içinde

5,0

(54 değerlendirme)

5,6

@n2rtechnologies

Hi, I checked your requirements and I am extremely interested in taking your project. We would like to grab this opportunity and will work till you get 100% satisfied with our work. So, what do you think? Could we be a match? If so, reply and let’s chat!

$25 USD 7 gün içinde

4,0

(35 değerlendirme)

6,9

@vashishtrupinder

Hello, I can start immediately as I am expert in sql and PHP. Here's how I propose to address the problem: Analysis: I'll thoroughly examine the stored procedure and its parameters to identify the root cause of the issue. Modification: Based on my analysis, I'll make the necessary modifications to ensure that the stored procedure fetches the correct number of products (14) for all areas. I'm ready to start immediately and commit to delivering the solution within the day. Additionally, I'm willing to sign your NDA to ensure the confidentiality of your code. Looking forward to resolving the issue and providing you with a reliable solution. Best regards,

$20 USD 40 gün içinde

4,8

(40 değerlendirme)

5,9

@ManzoorH

Hello I am full time freelancer with more than 8 years of experience in .NET, Winforms, WPF, SQL Server, .NET Core, WEB APIs, WCF, Entity Framework, Blazor, React and NODE.JS. Please come on chat and lets discuss the project scope and flow in details. Thank you for reading my proposal. Regards Manzoor

$20 USD 3 gün içinde

4,6

(19 değerlendirme)

5,2

@AITSoft

Hey there, I have 4 years of working experience in web technologies and I have a strong working knowledge of every possible framework which is in the market. In terms of client-end I know: MySQL and SQL Also I have done tons of work on freelancing career. I am waiting anxiously for a positive response from your side. And I have read your requirements as well. Thanks and regards, Shamshad

$25 USD 35 gün içinde

4,5

(2 değerlendirme)

5,4

@anaya8777

I can Resolve SQL Stored Procedure Issue. Please initiate a message for further discussion.

$15 USD 5 gün içinde

4,9

(15 değerlendirme)

5,0

@sonishubham

Hey There, As a seasoned Full Stack Developer with over 9 years of experience, I've encountered and successfully resolved numerous SQL challenges similar to what you're facing. My skill set includes a deep understanding of MySQL and SQL and I have consistently delivered results with an accuracy rate of about 98% to 100%. When it comes to stored procedure issues, I'm not only skilled in dissecting and troubleshooting but also adept at modifying existing criteria to achieve accurate results. Additionally, my sound understanding of database administration and debugging amplifies my ability to resolve such problems swiftly. Your project requires someone who's committed, reliable, and capable of delivering the desired results promptly. I pride myself on these very qualities as they are core components of my work ethic. Partnering with me guarantees you the optimal balance of experience, proficiency, efficiency, and above all––unwavering commitment to get the job done right. Let's fix this issue together and get your stored procedures functioning optimally in no time!

$20 USD 40 gün içinde

5,0

(7 değerlendirme)

4,5

@bhartikgr

i am ready to Start immediately I can Deliver within the day. Please share with me full detail. So I can check and fix these issue. Thanks.

$20 USD 40 gün içinde

5,0

(7 değerlendirme)

4,4

@baldevsharma0001

Dear Client, I am a SQL expert, I have gone through your requirements, and I have found myself suitable for this project. Previously, I worked on a couple of similar projects. Please allow me to work on this, and I request that you let me know your suitable time for further discussion. Thanks Baldev Sharma

$30 USD 40 gün içinde