Find Jobs
Hire Freelancers

Correct a calculation for 1 field in our stored procedure. Ongoing work AFTER this project.

$30-250 USD

Completed
Posted about 6 years ago

$30-250 USD

Paid on delivery
We have a stored procedures to create audit reports to verify if the amounts that the phone company has charged us are correct. There is an error in calculation for one of the fields. Once the error and the query details are understood it should not take 1 hour, to correct, but we understand the learning curve to start the work and are looking for a professionl that can do about 10hrs/week after this inicial test task. Please see the photo which has the excel spreadsheet print screen where you can see the field with the wrong value and also I have placed the correct calculation below and in the DOC that I attached. Below is the exact change that needs to be done: I = subscription , and is incorrect the formula is Formula for D = B-C D = amount charged with discount C = Discount amount B = amount charged without discount Forumula for “F” = (D-A)I = subscription , and is also incorrect Formula for D = B-C D = amount charged with discount C = Discount amount B = amount charged without discount Forumula for “F” = (D-A) F = Amount to contest of specific service (ex. 1 phone call not ALL phone calls) D = amount charged with discount A = Amount that should be charged according to contract. Please use the same algorithms to calculate services J and K J = 50 minute plan is also incorrect, use same formulas as I “subscriptions” K = 2,000 in grupo minutes is also incorrect, use same formulas as I “subscriptions” [login to view URL] and SP can be seen in the attached file.
Project ID: 16320478

About the project

11 proposals
Remote project
Active 6 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 possess expert level skills and experience in the technologies which you are looking for and I have successfully developed and implemented complex projects for some of the esteemed clients in US and Canada. I believe I can find solutions to all of your needs. Start a conversation with me today and get started to unravel the data insights you need.
$150 USD in 1 day
5.0 (1 review)
2.4
2.4
11 freelancers are bidding on average $166 USD for this job
User Avatar
Hi, I read your request. I understand that you need to make some changes in a stored procedure to correct calculations. I can provide you with the required modification.
$150 USD in 5 days
4.9 (17 reviews)
4.5
4.5
User Avatar
Hello Sir, I have 3+ years’ experience of DBA work supporting Microsoft SQL server DB's. I am already supporting 24*7 on call DBA support services. i have also experience in stored procedures . I will like to keep a long term relationship with you. Can you please share your best time for the chat so we can discuss further and move ahead. Looking forward to hearing from you soon. thanks
$200 USD in 3 days
4.4 (1 review)
3.0
3.0
User Avatar
I am an experienced Software engineer and Microsoft Certified Professional. I will do your project. Feel free to contact me for further discussion. Regards, Moeen Ahmed
$155 USD in 3 days
4.6 (2 reviews)
1.9
1.9
User Avatar
Hello just wanted to ask you from where are you pulling this data and i will just need a day to figure all out at start after that will tell you how much time I will need to fix all of that
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am proficient in web development using HTML5, CSS3, Javascript, jQuery, jQuery UI, Ajax, AngularJS, Bootstap, Foundation, Php, Asp.Net MVC etc. I have also have strong experience of software development using Foxpro, Visual Foxpro, C#, Asp.Net, MVC, Crystal Reports, Sql Server and MySql. I have developed various software related to Accounting, Inventory, Taxation, Production / Manufacturing etc. You have to check my portfolio for feedback and ratings for completed projects. Thank you, Pramod
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi... I am a certified SQL profesional having 7+ year of experience. i can correct this if all information provide by you is correct. so please give me this work.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BRAZIL
RIO DE JANEIRO, Brazil
5.0
36
Payment method verified
Member since Aug 17, 2010

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.