Convert Excel Macro to SQL Server Stored Procedure(repost)
$30-75 USD
Ολοκληρώθηκε
Αναρτήθηκε περίπου 12 χρόνια πριν
$30-75 USD
Πληρωμή κατά την παράδοση
I have a excel macro that is vb code that is about 563 lines total that currently looks at a database and does calculations and populates the excel spreadsheet. I need the macro to now be converted to T-SQL to run as a SQL Server 2000 stored procedure. I would like for the stored procedure to write the data to a table in the database it is in, and write the output to a file as .csv or excel. The goal is to have the stored procedure run via a sql job every day at a specified time. I can supply the database schema so you can reference the field names and datatypes. Please supply timeframe to complete when bidding. Time is crucial so please do not bid unless you feel confident that you can do the project without a problem. Feel free to ask questions.