Topic: tsql error.
i have the following piece of code. When i run the job i get an error,. Id,like to iclude todays date - one day in the subject of the mail.
give it a short gurus.
Incorrect syntax near '+' please help.
',
@subject = 'Daily Automated Naivasha Packhouses Work Summary for ' + convert(varchar(10),getdate()-1) + '.',
@attach_results = 'TRUE', @width = 1000,
@attachments='HCOSAutoReport.txt'