QUICK 2 hour Task to qualify freelancers for our other tasks -> MS SQL Optimization with excel report Output

The time spent on this project needs to be 1-2 hours (3 hours max) and 1 day to complete. If you can't complete the task in this time frame please don't bid

Currently one of our MS SQL stored Procedures EXEC CobFullClaro_load 1,2019 takes about 50min to complete. If you can reduce this to one half or one quarter the time please contact us as we are using this task as a filter to hire professionals to make fixes and improvements to this and other stored procedures on an ongoing basis. This task in itsself is MINIMALLY critical and ONCE AGAIN SERVES TO FILTER AND FIND PROFESSIONAL TO HIRE ON LONG TERM!

We can award you the job and create milestone if you can show us this optimization (print of before after time to run on your machine) and then release milestone once we run the job on our aws server and confirm the optimization.

Output of this stored procedure should be to excel with some formating (filter and freeze top row, font, and highlight some columns like the exemple excel that we attatched), currently we copy/paste results to excel then manually apply filter and other modifications and we want to avoid this. If you have pivot table/graph experience this helps very much!

Some details:

We have a mobile phone rental service and we need to audit the phone bill every month from the phone company then we need to recalculate the amounts that we will charge our clients. The stored procedure we are putting below is the primary report generators we use calculate amounts to charge our clients.

Currently it takes 50 min to load (on a [login to view URL] aws server) and has never been optimized for speed.

1) We're in the hopes that this can be significantly reduced (1/2 to 1/4 the time or less) with proper optimization.

2) we would like the output to go directly to excel with some modifications (filter/freeze top row, change font size, color columns). Example desired excel output attached (does not have desired pivot charts/tables/graphs)

Download link for MS SQL Database backup -> [login to view URL]

user -> freelancer

password -> freelancer01

Example execute the stored procedure for january 2019 and also extract below:

EXEC CobFullClaro_Load 1,2019 -- to load the data

EXEC CobFullClaro_Extract 1,2019 -- to extract

Cheers and good luck


Compétences : Administration de Bases de données, Programmation de bases de données, Excel Macros, Excel VBA, Serveur SQL Microsoft

en voir plus : blackberry task list sub tasks, need a cheap photographer for a wedding max 2 hour service wiulndt mind a new starter, 2 hour photoshop online service, sql job description example, sql developer skills resume, sql performance tuning tutorial, database optimization techniques sql server, sql developer skills required, sql programmer job description, t-sql developer responsibilities, junior sql developer job description, 2 of best developers freelancers, my client a young fintech company in dublin 2 are now looking to hire an experienced ms sql developer on a permanent basis with, translator for hire 2 hour chinese to english, 1-2 hour, how many slides for a 2 hour lecture, how many slides for a 2 hour presentation, 2 hour glucose tolerance test pregnancy normal range, 2 hour glucose tolerance test pregnancy, level of effort tasks ms project

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

Nº du projet : #18906676

4 freelance font une offre moyenne de $199 pour ce travail


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(23 Commentaires)

I am a financial expert and guru in Excel with over 35 years of experience across different industries. I have the skills to upload databases from SQL server into Excel and generate financial reports and charts. I have Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)

Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters Plus

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

Hi, I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. • Overall 6+ years of experience in Software Development Projects. • Ov Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)