Create SQLSERVER SP to create Excel file

終了済み 投稿 Aug 19, 2014 着払い
終了済み 着払い

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

エクセル マイクロソフトSQLサーバー

プロジェクトID: #6342921

プロジェクトについて

23個の提案 リモートプロジェクト アクティブ Sep 25, 2014

23人のフリーランサーが、平均£110 で、この仕事に入札しています。

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' ) もっと

£70 GBP 1日以内
(210件のレビュー)
8.0
cheapexcell

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

£142 GBP 3日以内
(105件のレビュー)
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 もっと

£50 GBP 3日以内
(59件のレビュー)
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 もっと

£150 GBP 4日以内
(9件のレビュー)
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 もっと

£83 GBP 2日以内
(14件のレビュー)
4.6
aminechafai14072

A proposal has not yet been provided

£100 GBP 0日以内
(6件のレビュー)
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 もっと

£99 GBP 1日以内
(4件のレビュー)
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 もっと

£77 GBP 3日以内
(9件のレビュー)
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 10日以内
(5件のレビュー)
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 もっと

£100 GBP 5日以内
(3件のレビュー)
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 もっと

£50 GBP 1日以内
(0件のレビュー)
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 1日以内
(0件のレビュー)
1.9
TonyForU

A proposal has not yet been provided

£150 GBP 3日以内
(0件のレビュー)
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 1日以内
(0件のレビュー)
0.0
wanes

A proposal has not yet been provided

£111 GBP 3日以内
(0件のレビュー)
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 2日以内
(0件のレビュー)
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 もっと

£155 GBP 4日以内
(0件のレビュー)
0.0
jefftaylor

A proposal has not yet been provided

£111 GBP 3日以内
(0件のレビュー)
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 もっと

£80 GBP 5日以内
(0件のレビュー)
0.0
levchuong

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

£150 GBP 10日以内
(0件のレビュー)
0.0