Combining a Query within a Variable String

[pagey47]

Im Looking to create a email that will have 3 tables aswell as some text as the body. I was thinking of declaring a variable and then building it up. Something like this...

SET @MESSAGE = 'Intro Text' +
SELECT * FROM ORDERS +
'Other Text'

etc..

I was just wondering if this was possible and if so what is the syntax. Ive been playing about but so far without any luck.

Thanks in advance
Nigel

 

[JamesLean]

You can combine text with the results of a query like this:

EXEC master..xp_sendmail @recipients = 'me@mydomain.com',
	@subject = 'Test',
	@message = 'This is the email text',
	@query = 'SELECT foo FROM bar'

But I don't think you can have text, then a query, then some other text etc.

--James