I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a regular basis requires a system code, it changes each day. I want to write an app, batch file, etc., anything that upon launching will get the system code for the day(either by manually passing the value through some sort of GUI, or based off of the date on the computer) and return it to me in a text file that I can copy and paste.
Any recommendations on a language that would make this task very easy?
WHERE DATE_FIELD >= convert(datetime, '2008-12-1 12:00', 120)
AND DATE_FIELD < convert(datetime, '2008-12-2 12:00', 120)
you can run this sql select, now its a matter of what you are familiar with to get it to a text file, you can do it with dts / ssis, c#, whatever else you may prefer
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
