I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column in the query. All rows will have the same week ending date in the column. The output file would be something like "NPQ_Asst_2010-11-12.csv"
November 12, 2010 12:56 PM
November 12, 2010 7:15 PM