Dave J.,

I completed the extra tests I needed, and I am still comfortable with what I wrote.  I was commenting a copy of the code to help make it understandable,...

Dave J., What would work better is if you try a ell me what I am doing, and then I can fill in the gaps where things don't make since. ...

Also just tried this:

SQLServer2005SP1-KB913090-x86-ENU.exe /quiet /norestart /instancename=HCM

This is what I got in the log file:

06/19/2007 10:20:10.627 ================================================================================

06/19/2007 10:20:10.627 Hotfix package launched

06/19/2007 10:20:13.314 Product discovery successfully completed during the install process...

I had started looking at that as well, but started finding some conversion issues between floats and varchar, then I lost all my work because my PC at home rebooted...

It is greyed out.  All it wants to do is apply SP 1 to all instances.

Karma, Actually, quite good!

David M., have you been able to test my latest update to the fn_BRound function?

Sergiy,

The value 0.666666 is precise to 6 decimal digits, so is 0.6666660000000000000.  They are equal, or a better word is equivalent.  The value 0.666666 does not represent all values between...

No, I don't.  In the first case, 0.666666 reprepresents precisely 0.666666.  Taking that number further would mean adding zeroes, if it went to 8 decimal digits it would look like...

Also, Sergiy, it would be interesting to see if you could hold a discussion without name calling or attacking individuals intelligence.  When people start doing that, it shows desperation on...

No Sergiy, I just needed to go to bed.  While it was daytime for you, it was late at night for me.  here is your answer:

0.666666 -> 0.6666660...  Why, because...

Say goodnight Sergiy.

Doesn't matter, as you you will say what ever you wish regarding my answers.  Bottom line, prove to us mathematically that Round to Even is totally inaccurate.  Showing us individual...

And it is your choice not to use it.  That doesn't mean that the rest of us has to live by your choice.  We are free to make what ever...

So, if using long division and I stop at 0.0450 (4 decimal positions of precision) and then do a bankers round to 2 decimal positions and round down to .04,...

Made another modification to my decimal version:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[fn_BRound] (

    @val decimal(38,20),

    @pos int

)

RETURNS decimal(38,20)

as begin

    declare @tmpval1 int,

            @tmpval2 decimal(38,20),

            @retval decimal(38,20),

            @tmpval3 decimal(38,20),

           ...