Resolve SQL Stored Procedure Issue - 28/03/2024 01:19 EDT
Budget: $15 – $25 USD
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 12 products only
2. Area 2 gives 13 products only
3. Area 3 gives 13 products only
4. Area 4 gives 13 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.
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 12 products only
2. Area 2 gives 13 products only
3. Area 3 gives 13 products only
4. Area 4 gives 13 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.