Lengkap

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”

[login to view URL] and SP can be seen in the attached file.

Kemahiran: SQL

Lihat lagi: Looking for Ms sql stored procedure send mail Workers or Work?, sql server stored procedure field loop, field name stored procedure classic asp, sql, microsoft sql server, 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

Tentang Majikan:
( 36 ulasan ) RIO DE JANEIRO, Brazil

ID Projek: #16320478

Dianugerahkan kepada:

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 Lagi

$150 USD dalam sehari
(1 Ulasan)
2.4

11 pekerja bebas membida secara purata $166 untuk pekerjaan ini

$133 USD dalam 3 hari
(20 Ulasan)
4.6
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 dalam 5 hari
(17 Ulasan)
4.5
$166 USD dalam 2 hari
(1 Ulasan)
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 Lagi

$200 USD dalam 3 hari
(1 Ulasan)
3.0
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 dalam 3 hari
(2 Ulasan)
1.9
gursukh

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

$222 USD dalam 3 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
$122 USD dalam 3 hari
(0 Ulasan)
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 Lagi

$150 USD dalam 7 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0