InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 07:17:39 GMT20http://www.sqlservercentral.com/Forums/Topic1418583-391-1.aspx[quote][b]Ed Wagner (2/11/2013)[/b][hr]Unfortunately, SQL Server doesn't like to have concatenated stuff passed to parameters. So, you could do something like this:[code="sql"]declare @strBody varchar(255);select @strBody = 'This is to test that today is ' + CONVERT(VARCHAR(12), GETDATE(), 101) + ' and it is a good day';EXEC msdb.dbo.sp_send_dbmail @recipients = 'someone@yahoo.com', @subject = 'Test', @body = @strBody;[/code][/quote]That was good. ThanksWed, 13 Feb 2013 07:28:04 GMTnewdba_sqlhttp://www.sqlservercentral.com/Forums/Topic1418583-391-1.aspxUnfortunately, SQL Server doesn't like to have concatenated stuff passed to parameters. So, you could do something like this:[code="sql"]declare @strBody varchar(255);select @strBody = 'This is to test that today is ' + CONVERT(VARCHAR(12), GETDATE(), 101) + ' and it is a good day';EXEC msdb.dbo.sp_send_dbmail @recipients = 'someone@yahoo.com', @subject = 'Test', @body = @strBody;[/code]Mon, 11 Feb 2013 11:46:00 GMTEd Wagnerhttp://www.sqlservercentral.com/Forums/Topic1418583-391-1.aspxI have to set up a sql job that sends an email suppose"This is to test that today is 02/11/2013 and it is a good day"EXEC msdb.dbo.sp_send_dbmail @recipients = 'someone@yahoo.com, @subject = 'Test', @body = 'This is to test that today is 02/11/2013 and it is a good day'Is there any way that whenever the job runs it puts the current date with "SELECT CONVERT(VARCHAR(12),GETDATE(), 101)"Mon, 11 Feb 2013 11:32:36 GMTnewdba_sql