Yes, xp_sendmail uses MAPI and need lots of icky configs to work and have all sorts of issues.

A 'better' way to mail-enable SQL Server is to use xp_smtpmail instead

I'm not going  to say I understand how, cause I don't - but I'm guessing that what you're seeing is result of truncation....

So, do you still have the problem?

If you do, please post some sample data and the offending query to reproduce it.

/Kenneth

Small correction - only CONVERT supports display styles, CAST does not.

/Kenneth

What's with the 'with ST'...? The example is querying for 'UU'..?

If you look stright in the extracode table for the account, how does that look?

You could also try to change...

Ah, no problem at all Steven.

I've never been to Iceland, though I'd like to visit there sometime.

From what I (think) I know about Icelandic naming standards, is that what we...

Ah, just realized that Mathew's solution did add a zero to make up 726.50.

/Kenneth

What about 726.5 then? Is it good as is, or should that be 726.50 also..? (since you wanted 2 decimals on 250.00)

/Kenneth

No, it's quite unnecessary.

If the update was attemped straight off, you could always check @@rowcount for how many rows was affected by the update. There is no error if rowcount is zero,...

Maybe get SQL Express and get a headstart finding out how things could be improved..?

/Kenneth

Close enough

When looking out the window, I'd imagine that the weather could be the same in Iceland as here, though I live...

Like this then?

select x.gt

from  (

        Select CustomerName,

               CustomerNumber, 

               FGoal AS FG,

               FSched,

               (cast(FGoal as numeric(30,2)) / FSched) * 100 AS gt

        from   DR

        WHERE  e='09'

        group...

Would this do?

select a.userID

from myTable a

where a.version# = 1.0

and not exists ( select * from myTable b where a.userID = b.userID and b.version# > a.version# )

/Kenneth

Looks like the data is from or to a '||' delimited file or similar.

As written I don't think it's a valid statement.

Could it be that it's supposed to be LIKE...

Try and see if this works.

(You just wanted the final grand total row, right?)

Select CustomerName,

       CustomerNumber,

       FGoal AS FG,

       FSched,

       (cast(FGoal as numeric(30,2)) / FSched)...