I need to run an automated query daily and update the information daily. I have created the quert script however I need help with writing script for the Export of the file:
I need to export the file to a Flat file, Lines Seperated by CLRF Colum Deliniated by Semicolon to a file with a file name such as "filedate.txt" so I need to know how to script saving the query below with the filename as date.
We are using Automate and the script is:
DECLARE @dt DATETIME
Set @dt = GETDATE()
WHERE PriceDate =