Okay, I can't stay out of it any longer.  David, you have put up a good argument, but it is time to end it.  No matter how much we try...

mengus,

Took a bit, but I see where you are coming from.  It looks like a case of semantics between your modification to my solution.  In mine, I choose to round...

I'll have to see if I can find a copy of Ken's book.  Your explaination helps, but to get a better understanding, perhaps additional books are worth the investment.

Thanks.

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...