<![CDATA[PunBB Forums - tsql error.]]> 2008-10-02T07:14:16Z PunBB http://punbb.informer.com/forums/topic/19838/tsql-error/ <![CDATA[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'

]]> http://punbb.informer.com/forums/user/13835/ 2008-10-02T07:14:16Z http://punbb.informer.com/forums/post/117915/#p117915