<![CDATA[PunBB Forums - tsql error.]]> http://punbb.informer.com/forums/topic/19838/tsql-error/ Thu, 02 Oct 2008 07:14:16 +0000 PunBB <![CDATA[tsql error.]]> http://punbb.informer.com/forums/post/117915/#p117915 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'

]]> Thu, 02 Oct 2008 07:14:16 +0000 http://punbb.informer.com/forums/post/117915/#p117915