Find Jobs
Hire Freelancers

Adjust MSSQL SP

$30-250 USD

In Progress
Posted over 10 years ago

$30-250 USD

Paid on delivery
The procedure SP_TestFinal almost does exactly what I need it to do. The problem I'm running into is that it appears that ACTIVESALES is only being populated with one ItemCode instead of all the ItemCodes in the group. The output of this query should be 29 [SP_TestFinal] @StartDate = '2013-6-1', @EndDate = '2013-11-1', @CompanyCode = 'OWPI', @WebProductGroupCode = '8028', @CommodityCode = 'M' I~~~ SELECT ( SELECT ISNULL(SUM([login to view URL]),0) FROM [login to view URL] i LEFT JOIN [login to view URL] sod ON [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] LEFT JOIN [login to view URL] soh ON [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] WHERE [login to view URL] = 'OWPI' AND [login to view URL] = '8028' AND [login to view URL] = 'M' AND [login to view URL] IN ( SELECT SOTypeCode FROM VwOsborneSalesSOTypeCodes ) AND [login to view URL] = 0 AND [login to view URL] BETWEEN '2013-6-1' AND '2013-11-1' Group By [login to view URL] ) + ( SELECT ISNULL(SUM([login to view URL]),0) FROM [login to view URL] i LEFT JOIN [login to view URL] sod ON [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] LEFT JOIN [login to view URL] soh ON [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] WHERE [login to view URL] = 'OWPI' AND [login to view URL] = '80281' AND [login to view URL] = 'M' AND [login to view URL] IN ( SELECT SOTypeCode FROM VwOsborneSalesSOTypeCodes ) AND [login to view URL] = 0 AND [login to view URL] BETWEEN '2013-6-1' AND '2013-11-1' Group By [login to view URL] ) ~~~ You can make the SP give the correct result with this query: UPDATe [login to view URL] SET ItemCode = '80281M' WHERE SONumber = 0000037945 AND ItemCode = 'S-80281M' ~~~ You can set it back to the wrong result with this query: UPDATe [login to view URL] SET ItemCode = 'S-80281M' WHERE SONumber = 0000037945 AND ItemCode = '80281M' ~~~ I need it modified so that the ItemCodes this error is fixed without breaking the underlying logic.
Project ID: 5155729

About the project

20 proposals
Remote project
Active 10 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
I'm experienced in MSSQL, let me do this for you very quickly. I've done some projects for you with very good result
$126 USD in 2 days
4.4 (20 reviews)
5.3
5.3
20 freelancers are bidding on average $111 USD for this job
User Avatar
Hi, My name is Janos, I'm from Hungary and would like to help you on this. I have a vast experience with MSSQL and ERP/sales systems and can go through the database and SP and ensure it returns the correct data without breaking the existing logic - if that is possible. If not, I can explain why I don't believe that is possible and what I suggest to resolve the issue. (However I believe it should be possible to modify the SP and not require any other changes to the db). I'm available to discuss over skype. I look forward to working with you. thanks & regards, Janos
$157 USD in 2 days
5.0 (18 reviews)
6.7
6.7
User Avatar
Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expertise in writing complex queries with proper joins and index selection. In past, i involved in balancing between concurrency and locking and lock escalation. Thanks, Ajay
$166 USD in 10 days
4.9 (47 reviews)
6.6
6.6
User Avatar
Expert here. Look at my feedback. Let me do it for you and you will love my qualification with the best result. If you choose me the winner, contact me via skype liemvt90 Many thanks, Liem
$100 USD in 3 days
5.0 (13 reviews)
5.4
5.4
User Avatar
Hi, I'm very interested helping you creating your sql SP, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details about your sql SP (specifications, deadline,...), so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$105 USD in 3 days
4.5 (26 reviews)
5.2
5.2
User Avatar
can we talk? .
$55 USD in 1 day
5.0 (26 reviews)
4.7
4.7
User Avatar
I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) ,PHP, WordPress, SharePoint, VBA, C, C++ and Vb 6 Scripting Languages jquery and javascript, Third party tools like Telerik, Infragistics and Reporting tools (Crystal Reports, Sql Reporting Services and Oracle Developer). Looking forward to your feedback. Regards, Muhammad Ali Safder
$38 USD in 3 days
5.0 (25 reviews)
4.5
4.5
User Avatar
Hi I want to do the project. I have more than 10years experience in database administration an pl/sql programming. Thanks.
$222 USD in 10 days
4.9 (30 reviews)
4.7
4.7
User Avatar
Hi, i have 5+ year of working experience and i am sure that i can help you to cmplete this project cn we discuss about it? Please visit my profile once for my past work Thanks Arpit
$45 USD in 1 day
4.5 (8 reviews)
4.3
4.3
User Avatar
Hi. I am certified MS SQL Server expert. Would be glad to help you with this project. Regards, Yuri.
$83 USD in 5 days
5.0 (18 reviews)
3.7
3.7
User Avatar
I have reviewed the test data provided and using MSSQL 2012, the query returns the right value of 29. I do not see anything which is in error. Sold 10 of the main item Sold 19 of other parts I would be happy to work with you on teamviewer to solve this issue.
$155 USD in 0 day
4.9 (4 reviews)
3.9
3.9
User Avatar
Hi This is bhargava . I am ready to provide quick and efficient solution . i am expert in procedures and functions. I am unable to open your bak file can you please send as sql file or test file
$50 USD in 0 day
4.8 (16 reviews)
3.7
3.7
User Avatar
一个有效的提议尚未被提供
$54 USD in 2 days
4.8 (9 reviews)
3.3
3.3
User Avatar
Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,
$147 USD in 3 days
2.8 (4 reviews)
4.3
4.3
User Avatar
Hi, Hope you find this message in good health. I have great hands on SQL Server and Stored Procedures. I do work on SP on daily basis. I can fix your SP and modify so that it return expected output. Hope to hear from you soon. Thanks!
$111 USD in 3 days
5.0 (5 reviews)
2.0
2.0
User Avatar
Hi, I am having more than ten years of experience on SQL. I completely understand your requirement and will deliver assignment within given time frame. I am ready to start immediatly. Looking for positive response from your side. Thanks
$50 USD in 1 day
5.0 (1 review)
1.9
1.9
User Avatar
Hi turn123, I'm Gerardo and I belong to a company located in Buenos Aires, Argentina with Operations in USA that is composed with highly trained professionals with experience in all kind of web development. I have been working with SP for years, so I would like the chance to know more about the project to help you to finish the job. Thanks in advance
$166 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HI, I have 4 years experience with SQL. I will do it morte accurately. I believe in long term relation.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Toccoa, United States
5.0
418
Payment method verified
Member since Dec 14, 2004

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.