If you have SQLMail set up and it is working properly, you could always try the following:

EXEC master.dbo.xp_sendmail @recipients = 'you@yours.com'

    ,@message = 'message here'

    ,@subject = 'subject',

    ,@query = 'select name,size,maxsize,filename...

how about something like this:

SELECT

 (SUM(P0.Total1) + SUM(P0.Total2)) AS GTotal

FROM

 (

 SELECT

  (A.qty1*price1) AS Total1,

  (A.qty2*price2) AS Total2

 FROM A

&nbsp P0

I had a similar issue a while back.... I found using the following query helped out quite a bit, especially when I scheduled it to run at specific intervals:

Checkpoint

go

Backup...

you could also try this:

SELECT CAST(CONVERT(char(10), getdate(), 112) as datetime)

Hi Travis,

Is this position for American citizens only, or will you accept CV's from people living abroad that are willing to relocate?

Thanks,

Anton

Hi Chris,

Well, remember I told you that I had a dog of a problem, well, here is the query that I wrote to sort out the problem. You...

Hey there,

I assume by this problem, that you have a trigger on this table.... Even if this is not the case, your query is, for some reason, trying to update...

Hi Mattias,

Have you tried CONVERT(decimal,ColumnName). I used a decimal here as your exmaple in your post showed 0.365

Anton

Hi Chris,

Here are a couple of suggestions....

  1. Firstly, is there anyway you could get the initial output file to output the dates in a long format? i.e. 1 Jan...