BR rounds numeric representations, not real values represented by decimal number.

BR rounds numbers

That's why BR cannot round 2/3

BR works with numbers not fractions

because there is no way to supply 2/3...

Bankers Rounding does not get it wrong

Bankers Rounding will round correctly any number given to it according to the rules of Bankers Rounding specified

Bankers Rounding will produce different results to...

Any method you choose will produce some form of 'ruined' value. My suggestion to use varchar as input to the function will remove any ambiguity within the function itself and...

By the way, David Burrows's code gets it wrong with 2.265001

Yep

Isn't 612.945 supposed to result in 612.94

With 2K5 I'd be tempted to use CLR. In 2000 I did write two extended procs, xp_direxists (check if dir exists) and xp_print (to write/append to output file).

I think a...

Was actually wondering when you'd show up on this, Mr. Burrows...

Thanks Jeff

Coming in on the tail end (of both threads) I thought I would try it this way

DECLARE @Result money,@Fraction int,@Interim float(53)

DECLARE @Digit int,@Counter int

SET @Result = CAST(FLOOR(@p1) as...

And I bet is had nothing to do with 2/3

Error messages are stored in master.dbo.sysmessages  (sys.sysmessages for SQL2005)

I believe the error you are referring to is number 9002

The log file for database '%.*ls' is full. Back up the transaction...

Notwithstanding the previous posts and sorry to duplicate this but I agree that profiler is the choice of weapon here, however difficult or painful it may be to get used...

1. Due to data type precedence the char column will be implicitly converted to varchar

2. Varchar comparisons ignore trailing spaces

3. Therefore if both columns contains the same chars, excluding trailing spaces,...

how in the heck did you figure that one out

Too many years of programming, far too many to...

Try this

osql -S "servername;app=appname"

Sergiy's solution will not show databases that have never been backup up which may be the reason why one is missing, this is my solution

SELECT DISTINCT sd.name,bs.backup_finish_date

FROM master.dbo.sysdatabases sd

LEFT...