Ολοκληρωμένο

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

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”

[url removed, login to view] and SP can be seen in the attached file.

Ικανότητες: SQL

Περισσότερα: Looking for Ms sql stored procedure send mail Workers or Work?, sql server stored procedure field loop, field name stored procedure classic asp, stored procedure search field, sql2005 save img file stored procedure, mssql stored procedure read file, sql server agent check file stored procedure, stored procedure convert function, t_sql stored procedure, update stored procedure, sql stored procedure check expiry date, xml path stored procedure, sql database schema stored procedure, max work file, windows applications create stored procedure page, stored procedure dump phpmyadmin, return info stored procedure tsql, sql xml stored procedure, sql stored procedure return table

Σχετικά με τον Εργοδότη:
( 21 αξιολογήσεις ) RIO DE JANEIRO, Brazil

Ταυτότητα Εργασίας: #16320478

Ανατέθηκε στον:

puneethshanth

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 believ Περισσότερα

$150 USD σε 1 μέρα
(1 Κριτική)
2.4

12 freelancers are bidding on average $165 for this job

$133 USD σε 3 μέρες
(6 Αξιολογήσεις)
2.8
OrangeTechsol

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 kee Περισσότερα

$200 USD σε 3 μέρες
(1 Κριτική)
3.0
reedsystems

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 σε 5 μέρες
(3 Αξιολογήσεις)
2.1
moeenahmed21

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 σε 3 μέρες
(1 Κριτική)
0.9
malavshelat

Hi there ! This is Malav shelat. Below is the proposal for your project based on my skills. Skills Summary: - Globally certified SAS programmer for Base SAS and data manipulation techniques. - I have 2.5 ye Περισσότερα

$155 USD σε 3 μέρες
(1 Κριτική)
1.1
gursukh

I have 5 year experience. I can show you my previous [login to view URL] can we discuss please.

$222 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
kleosims

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 σε 3 μέρες
(0 Αξιολογήσεις)
0.0
$166 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
$122 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
pramodv

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 Περισσότερα

$150 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
a7garg

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 σε 3 μέρες
(0 Αξιολογήσεις)
0.0