Hi All,
I have a SQL table with a submit date column and other fields. A stored procedure is created to pull the data from this table where submit date = today's date.
On a 24 hour basis, I would like to execute the stored procedure and write the output to a new text file with today's date as the file name (eg: 2014-03-05.txt).
I have researched couple of options like using a webservice or windows service or even doing it through the stored procedure. I am new to above all the options, so I dont know which one would be the best/feasible one for my situation. Any suggestion is highly
appreciated.
Thanks.
Go to the complete details ...