Tamamlanmış

Task to Select capable developers for long term support -> SQL Optimization with excel report output -- 2

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.

If you can optimize our stored procedure to run in one half to one quarter the time it currently takes and are able to output to excel with the minor reporting modifications below please submit your bid for the number of hours you took to do the work and we will create the milestone and free it upon confirmation that it is working as required. After this we will post for you our jobs for long term development.

We are using this SQL optimization project to evaluate and select experts for our other ongoing projects, this optimization itself is MINIMALLY critical (we use it 1 time a month and waiting 50 min is not a problem) and the most important factor here to find qualified SQL experts who can improve eficiency (time ) the stored procedure takes to run and improve the output format (to excel with filters, headers etc).

We can award you the job and create milestone if you can show us this optimization and then release it once we run the job on our aws and confirm the optimization.

Output of this stored procedure should be to excel with some minimal 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.

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

Download link for 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

Beceriler: Veri Tabanı Yönetimi, Veritabanı Programlama, Excel Macros, Excel VBA, Microsoft SQL Server

Daha fazlasını gör: aspdotnetstorefront support sql server 2000, remote support sql, article rewritters wanted article long term project, how to create maintenance plan in sql server 2012 step by step, sql server maintenance plan script, sql server maintenance plan add task, sql server 2016 maintenance plan best practices, how to create maintenance plan in sql server 2016 step by step, sql server database maintenance plan, sql server maintenance plan best practices, how to create maintenance plan in sql server 2014 step by step, article writers long term work, authors long term contract, bpo projects long term contract, check website support sql injection, converting web site xhtml beneficial long term, daily long term articles, texcel vba and sql expert long term relationship, texcel vba and sql expert: long term relationship, linux kernel long term support releases

İşveren Hakkında:
( 35 değerlendirme ) RIO DE JANEIRO, Brazil

Proje NO: #18910483

Seçilen:

vaidyag

HI, I have excellent experience in database programming. I have worked on various databases like Oracle, MYSql, Sql. I have worked on various projects like tuning, writing complex queries , or working on full f Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(12 Değerlendirme)
5.4

Bu iş için 8 freelancer ortalamada $137 teklif veriyor

schoudhary1553

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. Daha Fazla

$250 USD in 4 gün içinde
(23 Değerlendirme)
5.7
intemo

Hi! I offer you my skills for your project. But - i try to restore your database from backup and have error. Maybe i have some differernt version from your SQL server. Can you provide backup as SQL script with data?

$45 USD in 3 gün içinde
(24 Değerlendirme)
4.7
shobhitpundir

Hi There, I've read the description and confident that I would be able to complete it today only!!! I'm downloading the DB and will restore it to review the SP. Please connect over chat if you would like to shar Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
3.7
vw7590795vw

Please message me. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.2 years experience in MS SQL Server and 6.4 years experience in SSRS, SSIS (Import / Export). Please let me Daha Fazla

$250 USD in 0 gün içinde
(14 Değerlendirme)
3.9
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we Daha Fazla

$144 USD in 3 gün içinde
(5 Değerlendirme)
3.5
nbprince

Hey, yes I am expert in SQL Server and in excel formulas as well. I can handle both tasks and will show outputs in excel sheets.

$100 USD in 3 gün içinde
(1 Yorum)
0.0
i4ConsultantDev

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 Daha Fazla

$73 USD in 5 gün içinde
(0 Değerlendirme)
0.0