Create SQLSERVER SP to create Excel file
£20-250 GBP
Paid on delivery
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
Project ID: #6342921
About the project
23 freelancers are bidding on average £110 for this job
Hi, it can't be done in sqlserver unfortunately ==================================================================================
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 More
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 More
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 More
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 More
Hello, I am sure I can do it. Will have to research a bit... Thanks, AccuPro - Providing simple solutions to complex problems!
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
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
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.
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 More