Create SQLSERVER SP to create Excel file

Mbyllur Postuar Aug 19, 2014 Paguhet në dorëzim
Mbyllur Paguhet në dorëzim

Hi

The following is required:

SQLserver has MYQUERIES table contining a SELECT query to be executed and a file path.

I need a Stored Procedure that can take an MQ_ID as a parameter - from that lookup the query to be executed plus the output file path.

The SELECT query will be executed, the file saved to the path [as XLSX and as CSV], the 'success/failure' status logged and the outcome outputted [eg 1=success,2=failure]

I will be calling the SP from PHP, that part is all done - just need a SQLSERVER guru to do the create Exceldoc part. I've tried doingin in PHP but it takes forever and have memory issues - it can all be done in SQLSERVER I'm sure.

I am runnging SQL2008 - needs to be tested with 2012 in case we have to upgrade at some point.

Thanks.

Gavin

Excel Server Microsoft SQL

ID Projekti: #6342921

Rreth projektit

23 propozimet Projekti në distancë Aktiv Sep 25, 2014

23 profesionistë freelancer dërguan një ofertë mesatare prej £110 për këtë punë

sumon355

Hello, I am very much interested to do this work as i am experienced a lot with these kind of works. I already did similar type of work. But one thing i am not clear, do you want write the status('success/failure' ) Më shumë

£70 GBP për 1 ditë
(210 Përshtypje)
8.0
cheapexcell

Hi, it can't be done in sqlserver unfortunately ==================================================================================

£142 GBP për 3 ditë
(105 Përshtypje)
6.5
sswijaya

Hi, Let me help you to build a stored procedure to export query result to csv file. I'm sure this can be done through SQL Server using cmdshell or openrowset so that will solve your memory problem. Can you provide Më shumë

£50 GBP për 3 ditë
(59 Përshtypje)
6.3
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development arou Më shumë

£150 GBP për 4 ditë
(9 Përshtypje)
5.1
weblogicsoftware

Hello,We are very experienced in ASP.NET/C#/SQL Server. I am ready to start the project right now, and finish this on time. you can see my review on freelancer, no negative/bad/incomplete feedback. i always do work as Më shumë

£83 GBP për 2 ditë
(14 Përshtypje)
4.6
aminechafai14072

A proposal has not yet been provided

£100 GBP për 0 ditë
(6 Përshtypje)
4.1
acronymsolutions

Hi, I have gone through your requirements .I am a DBA at CMMI-5 Level company since August 2010.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your wo Më shumë

£99 GBP për 1 ditë
(4 Përshtypje)
3.9
rightfreelancer7

I am a professional software engineer with 9+ years of experience. I am very talented programmer with the following skills c, c++ , java ,sql,plsql, UNIX, Linux,SSH, PHP, Jsp ,Apache Server, jboss,AWS, Js , advanced j Më shumë

£77 GBP për 3 ditë
(9 Përshtypje)
3.1
AccuPro

Hello, I am sure I can do it. Will have to research a bit... Thanks, AccuPro - Providing simple solutions to complex problems!

£250 GBP për 10 ditë
(5 Përshtypje)
2.8
yubor

Hi. Could you describe your requirements more detailed? If you need to get this files as response on user request only, then it will be more suitable to create 2 SP's that will produce text output in Excel XML and CSV Më shumë

£100 GBP për 5 ditë
(3 Përshtypje)
1.5
hmaftah

Greetings! This is Hamza and I work as a IT consultant for several key accounts in my country (Morocco). I am a Microsoft Certified Professional in Implementing a Data Warehouse with SQL Server 2012. I have experience Më shumë

£50 GBP për 1 ditë
(0 Përshtypje)
0.0
kvarun49

Hi I am developer and I have experience in SQL Server and I can do this job, can we speak in details waiting for your response Thanking you Varun

£44 GBP për 1 ditë
(0 Përshtypje)
1.9
TonyForU

A proposal has not yet been provided

£150 GBP për 3 ditë
(0 Përshtypje)
0.0
kusinfonetcom

Hi We have good experience with MS SQL Server (creating Dynamic Stored procedure). We can complete this task within time and as per your requirement. Regards Kus Infonet

£111 GBP për 1 ditë
(0 Përshtypje)
0.0
wanes

A proposal has not yet been provided

£111 GBP për 3 ditë
(0 Përshtypje)
0.0
vw6896794vw

5 Yrs of Production experience in SQL with my current employer. I have been playing with excel in SQL for last 5 Years. I can do it.

£221 GBP për 2 ditë
(0 Përshtypje)
0.0
nejavmehta

I am Master Of Science in Software Systems and having working experience of 5+ years on SQL Databases. i also have executed good amount of projects which involves SQL and MS EXCEL, MS Access Databases integration. i Më shumë

£155 GBP për 4 ditë
(0 Përshtypje)
0.0
jefftaylor

A proposal has not yet been provided

£111 GBP për 3 ditë
(0 Përshtypje)
0.0
centaphi

Hi, I'm a passionate certified sql developer with more than 6 years of experience and I would love to work on this project. I wanted to ask about the part "the 'success/failure' status logged " - is there another Më shumë

£80 GBP për 5 ditë
(0 Përshtypje)
0.0
levchuong

Đề xuất vẫn chưa được gửi

£150 GBP për 10 ditë
(0 Përshtypje)
0.0