stupid sql problem

[TechJatt]

Ok, I'm using xp_sendmail to send reports to users from 2 queries. The problem is that the e-mails are really ugly, so I want to make them just a little more readable.

So, my question is, how do you insert a few blank lines in between the 2 queries? I want it so that it'll display the first query, a couple empty lines, then the 2nd query.

I tried: Doing a " print ' ' " gives me an access violation error, and doing a " SELECT '' " puts in a line of dashes.

Any suggestions?

 

[meckeard]

Hi,

Here is a way to create line breaks. I use it for sqlmail.

Create a variable called '@linebreak'
declare @linebreak varchar(20)

-- Create a variable that is a line break.
set @linebreak = char(13) + char(10)

Now use it where you need it.

HTH,
Mark