Create SQLSERVER SP to create Excel file
£20-250 GBP
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
ID Projekti: #6342921
Rreth projektit
23 profesionistë freelancer dërguan një ofertë mesatare prej £110 për këtë punë
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 Më shumë
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ë
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ë
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ë
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 Më shumë