Hey all.I'm having a lot of success with all of my queries and sending results through a SQL job. The jobs send HTML emails and all is working pretty well.Unfortunately I have a number of queries and they are all very large.Is it possible to declare more than one variable to hold query data and then reference them within the job?Example....DECLARE @MyQuery1 varchar(max)DECLARE @MyQuery2 varchar(max)SET @MyQuery1 = <query>SET @MyQuery2 = <query>EXEC msdb.dbo.sp_send_dbmail@recipients=N'me@me.com',@body=@MyQuery1 + @MyQuery2,@subject ='Subject',@profile_name ='ProfileName',@execute_query_database = 'db',@body_format = 'HTML'
Multiple queries within sp_send_dbmail ?
Posted - 2009-05-22 : 13:03:23
