Terminé

3 SQL stored procedure improvements

Our primary service is to rent mobile phone lines and we need to audit the phone bills that we receive to see that the mobile operator is charging us correctly and also need to bill the end users.

We have stored procedures that create both the audit and the re-bill reports and we do a simple copy/past to excel but we need to add a few feilds to the reports and make some other improvements.

Our objective is to start with small task so that the developer can gradually become familiar with the DB to then continuously make new reports, improvements etc. Our current SQL sepcialist is no longer able to do freelance for lack of time.

Please bid for this task only if your looking to do ongoing work because it will take some time to become familiar with the entire DB structure and we want to be able to have ongoing suport.

Task

1) create 3 new columns in our current report - We will tell you the name of the field and we will tell you the name of the fields that need to be added to generate the values that go in these new fields. This is something that our current SQL specialist could do in CONSIDERABLY LESS THAN 1 HOUR. Its VERY BASIC CHANGES with detailed explanation to complete the task.

The word doc DETAILS EVERY CHANGE we need and the excel is an example of the current output and also of how we expect the new output to be.

Compétences : Administration de Bases de données, Programmation de bases de données, Serveur SQL Microsoft, Tests de Logiciels, SQL

en voir plus : stored procedure performance tuning in sql server 2012, how to check performance of stored procedure in sql server, how to troubleshoot stored procedure performance in sql server, how to fine tune a stored procedure in sql server, how to improve stored procedure performance in sql server 2012, sql server stored procedure optimization tools, how to optimize a stored procedure using the execution plan, how to check performance of stored procedure in sql server 2014, sql stored procedure return table, sql stored procedure check expiry date, convert sql stored procedure oracle stored procedure, sql stored procedure return true, convert sql stored procedure oracle stored procedures, sql stored procedure usps api, sql stored procedure copy data, sql stored procedure zipcode distance, sql stored procedure tutorial, SQL STORED PROCEDURE, convert sql stored procedure, sql stored procedure table input

Concernant l'employeur :
( 32 commentaires ) RIO DE JANEIRO, Brazil

Nº du projet : #18751857

Décerné à:

codetod

Hi I am a database expert with 12 years experience in handling MS SQL and MySQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and trig Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(66 Commentaires)
6.3

12 freelance font une offre moyenne de $108 pour ce travail

mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several SQL projects of various complexities including working on new procedures and also making changes in existing ones as you need. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(89 Commentaires)
5.7
FerriSoft1

Hi! I started back with SQL 2005 Triggers, Pivoting, FETCH CURSORS, Dynamic SQL, SQL XML, SQL JSON, you name it I'm willing to solve one of the challenges without being awarded just so you cant test my work, with Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
5.1
wonwon424

Hi, employer. I am very familiar sql stored procedure I've read your requirements and I think I can do it. I have many previous works in this field and I will complete your project definitely. The person who wait Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
4.0
sreenivas2903

Hi i am expertise in sql query and query tuning and writing efficient stored proc if u really looking for serios skilled person ping me

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(14 Commentaires)
4.1
eaglepoint

Hi I am ETL/Data Engineer with 4+ years of industry experience. I have been working on deployment and design of EDW and analytics solutions using both clouds and on premises. I have expertise in sql, redhsift, mssql se Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
3.1
prerak121

Hi, i am excited to work on this project. i will finish this issue in 1-2 hours . i am sql developer and having 3 years of experience. Please give me an opportunity. thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
0.3
Vihtori92

Dear Client!. How are you? I am a mobile and web developer. My First goal will always be to meet your needs and deadline. When working on a new project, I can have a clear understanding of your needs and vision of t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
estebansalpeter

Hi, my name is Esteban Salpeter and I'm an experienced developer, with many years on different platforms. You can check out my portfolio to view some of my work. Your requirement is very clear, I've done queries and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
istackgroup

Hi, I AM A ORACLE DBA CERTIFIED 10g, 11g. I have strong expertise in databases and stored procedures. I am a TOP RATED SELLER ON DIFFERENT SITES. I am Awais have done MS/[login to view URL] in Computer science, I am a software engi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
kyosra

Hi The task is easy I am a computer engineer student I have experience with SQL I agree to do a test work to convince you before hiring me, I will create the first column as a test if you are satisfied I contin Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.0
thetimesedu

Hi I have an experience of 3+ years my strengths include:- Strong skills in SQL development An in-depth grasp of SQL reporting, analytics and business intelligenceGreat expertise in processing data and flowcharting t Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0