I am trying to create a SQL Stored procedure that will create a report on a nightly bases.
The requirement for the file name is mrpt.mmddyyyyhhmm.txt
I need to have my stored procedure name the file this way so that no one has to touch it manually.
The best I have been able to get is it naming the file mrpt.mmd (the mmd sets as the extension of the file and it cannot be opened).
Thank you in advance for any help with this issue.