Viewing 15 posts - 25,756 through 25,770 (of 26,487 total)
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,...
June 19, 2007 at 2:28 pm
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. ...
June 19, 2007 at 12:31 pm
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...
June 19, 2007 at 10:36 am
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...
June 19, 2007 at 10:32 am
It is greyed out. All it wants to do is apply SP 1 to all instances.
June 19, 2007 at 10:24 am
Karma, Actually, quite good!
David M., have you been able to test my latest update to the fn_BRound function?
![]()
June 19, 2007 at 9:49 am
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...
June 19, 2007 at 7:32 am
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...
June 19, 2007 at 6:45 am
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...
June 19, 2007 at 6:24 am
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...
June 19, 2007 at 6:17 am
Say goodnight Sergiy.
June 18, 2007 at 11:26 pm
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...
June 18, 2007 at 11:25 pm
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...
June 18, 2007 at 11:03 pm
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,...
June 18, 2007 at 10:40 pm
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),
...
June 18, 2007 at 10:00 pm
Viewing 15 posts - 25,756 through 25,770 (of 26,487 total)