İptal Edildi

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

If you can do this task and reduce in 50% or more the time it takes to run we are interested in paying you for this task and assigning you new tasks! Just run the sp on your local machine and show us the time it took originally and then run it again after optimization and show the time improvements and we will hire you and pay for the job.

We are using this SQL optimization project to evaluate and select experts for our other ongoing projects, this optimization itself is MINIMALLY critical and the most important factor here to find qualified SQL experts who can improve eficiency (time) of the stored procedure 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 45 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/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 AudFullClaro_Load 1,2019 -- to load the data

EXEC AudFullClaro_Extract 1,2019 -- to extract

If you

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

Daha fazlasını gör: write code transfer data sql server excel, sql bak excel, mysql excel report, automating reports using sql and excel, export ssrs report to excel with parameters, cognos report performance tuning, execution optimization cognos report studio, excel report builder download, export ssrs report to excel automatically, export ssrs report to excel in multiple sheets, export ssrs report to excel programmatically, sql access excel vba, league soccer system excel report, sql statement excel, generating excel report aspnet, sql 2005 excel, data extract excel report, getting data mdb output excel report, excel report php color, extract sql data excel file

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

Proje NO: #18904220

Bu iş için 9 freelancer ortalamada $150 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
Developer000

Feel fee to contact me for SQL Optimization with excel report [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] Daha Fazla

$150 USD in 3 gün içinde
(4 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 2 gün içinde
(5 Değerlendirme)
3.5
wbslivera

Hello, I am Oracle certified professional java programmer and have Bsc.IT. I work as oracle EBS techno functional consultant and used to develop many complex quires, packages so I might able to help you. Please provide Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.9
maguirrer

Hello, I can help you with this project, please send me a message (just to know if it is still open) and I will start working on it inmediately.

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

Hello, I have read the project details you need Optimized SQL with excel report output can do the job please contact me on chat for discussion. thanks

$155 USD in 3 gün içinde
(1 Yorum)
0.0
bluebear1888

How are you? I am very interested in your task. I read your proposal carefully. I am a talented and experienced these field expert. I can complete your task perfectly. I want to know your task in detail. Pl Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
vijaykrishna0497

Hey, I can optimize your stored procedure definitely. i can give you trust in this. I have experience in working with these stored procedures earlier in pl/sql and mssql. i need some more time of 2 days to work on t Daha Fazla

$111 USD in 2 gün içinde
(0 Değerlendirme)
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