Hi, with some help today I was able to get my stored procedure running
and have the results emailed to me. However, this is how its showing
up:
Accounting_Year WK_IN_FYEAR Location
GL_Account
Col Data Difference
--------------- ----------- ------------------------------------
----------
-------------------- -------------------- --------------------
2007 49 Test1
500-001
-2587872.0200 -2587872.0200 .0000
2007 49 Test2
500-001
-3344713.5000 -3344713.5000 .0000
2007 49 Test3
500-001

Is there anyway to line them up side by side properly? When i have two
colms selected the format comes out ok. Thanks for all the help
again!

Here is the sp:

CREATE PROCEDURE [dbo].[spEmailVariance]
(
@SubjectLine as varchar(500),
@EmailRecipient VARCHAR(100)
)
AS

DECLARE @strBody varchar(5000)
set @SubjectLine = 'Weekly Flash Update'
SET @strBody =

'Select statement'


exec master.dbo.xp_sendmail
@recipients= 'XX (AT) XXXX (DOT) com',
@subject= @SubjectLine,
@query = @strbody

RETURN
GO

Take a look at the @width and @attach_results parameters of xp_sendmail.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

On Dec 14, 7:52 am, "Plamen Ratchev" <Pla... (AT) SQLStudio (DOT) com> wrote:
You are awesome! That works... I didnt use the @attach_results TRUE
because i was getting a system error. I used @width set to 170 and
that worked fine.