hello all,

I a trying to run an extract using a job, the file must have the date
appended to it, any idea on how I can do that?


exec master..xp_cmdshell

'bcp "select id+name + paddress from haltondb.marie.dailyimport" queryout
"\\hrpalarm\DailyImport\Dailyimport.txt"+datetime -c -T'



MS Sql Server LazyDBA home page