Can't.  Implicitly promised Jeff I wouldn't argue with you anymore in public.

Jeff,

Okay, I will.  Nuff said about this.

Lynn

(ps you spelled my last name wrong in your edit earlier in the post)

Unfortunately, you didn't tell me to what precision you wanted the values rounded or if I am to round the total or each value first.  Stats prof taught me that...

Unfortunately, I don't have access to application where I had to use the bankers round.  It is my previous employers in-house software, written in COBOL using ISAM databases with all...

I think you will finally understand when pigs fly.  You just don't seem to get it and I obviously don't have what it takes to convince you otherwise.  Like I...

Sergiy,

You are definately a Type A personality.

Yes, the money type goes to 4 decimal places, but unfortunately, REAL MONEY doesn't, so going to 4 decimal places doesn't help when the...

I reread his post, but not withstanding,, I have never used a bankers round in any statistical or scientific calculation.  I have used it in accounting and tax applications.

Sergiy,

You are missing the point, there is a use for the bankers round.  You are making things more difficult than they really need to be.

Jeff,

I'll take that as your excuse,...

Sergiy,

The bankers round isn't meant to be used in scientific or statistical calculations, and nobody missed anything in 5th or 6th grade.  I hav had to use the bankers round...

Here is a comparision between the function I wrote and the STR method:

select

dbo.fn_BRound(612.945, 2),...

Am I doing something wrong here:

select

str(612.945, 10, 2) -- returns 612.95, not...

Does Microsoft ever know what's really best?  What I implemented has helped.  I understand how the indexes can help, but what I still don't understand are statistics.  What I have...

Here is what I came up with:

CREATE FUNCTION dbo.fn_BRound (

    @TestValue decimal(38,12),

    @pos int

)

RETURNS money

as begin

    return round(@TestValue, @pos, case when (nullif(round(@TestValue * power(cast(10 as decimal(38,12)), @pos),0,1),round((@TestValue * power(cast(10 as...

Without digging into myself at the moment, I'd say the problem is using float.  This is an imprecise numeric representation.  Try changing the floats to a large decimal, and see...

Why are you using the view v_div_all in v_rpt?  The only field you are using from that view is v_div_All.Div_Dep and this is the same as div.dion from the table...