Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satheesh
Posting Yak Master
152 Posts |
 Posted - 2013-07-17 : 08:48:14
|
| Hi all,I tried to scheduled and save a Report Via SSRS. The Exporting file name need to be in this format -- 17July2013_NewSystem.csv I have tried using @timestamp in file name, but the file was saved like this 2013_07_17_090529_NewSystem How to specify the filename to get the desired format ie. the file name deposited in the folder be -- 17July2013_NewSystem.csv18July2013_NewSystem.csv (for tomorrow and so on)Any help will he highly appreciated.ThanksRegards,SG |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-17 : 11:07:41
|
| How are you passing value for @timestamp?use something likeSELECT @timestamp = REPLACE(CONVERT(varchar(11),GETDATE(),113),' ','')------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
File Name