Viewing 15 posts - 1,516 through 1,530 (of 3,544 total)
| Again, this is a business decision that a company needs to make, not us in IT. |
Yes. IT are...
June 28, 2007 at 5:06 pm
erm! did you not state that
1/3 is
(int) 1 divided by (int) 3
however:-
1.0 divided by 3.0 as (money + implied zeros) = 0.3333(0)
select cast(1.0 / 3.0 as money)
1.0 divided by...
June 28, 2007 at 6:19 am
OK for the last time
1 divided by 3 as (money + implied zeros) = 0.0000(0)
1 divided by 3 as (decimal(12,6) + implied zeros) = 0.000000(0)
0.0000(0) - 0.000000(0) = 0.000000(0) =...
June 28, 2007 at 3:49 am
| David Burrows was struggling to prove his point about "implied zeros" fut (sic) he failed. |
No I did not...
June 28, 2007 at 2:45 am
Quite right, well put ![]()
June 28, 2007 at 2:45 am
But it was your statement that decimal 0.3333 is not equal to 1/3 and cannot represent 1/3 for BR purposes.
Not mine ![]()
So, what is your...
June 27, 2007 at 4:41 pm
I thought we had settled this, that as you can't.
Because 1/3 = 0 as you stated before, it is an expression, that is evaluated to (int) 1 / (int) 3
to get...
June 27, 2007 at 3:54 pm
| X.XX50 value represents values X.XX50(0) .. X.XX50(9) |
Sergiy,
Surely if TR is to produce a value X.XX50 then the...
June 27, 2007 at 3:20 pm
Depends
could be
0x0000000003000000
or
0x0100000003000000
or
0x555555555555D53F
btw who's Davis ?
now you answer my question ![]()
June 26, 2007 at 7:27 am
Sergiy,
You go to your local store and purchase an item priced at 33 cents (marked as 0.33)
You give the item to the storekeeper plus 1 dollar
The storekeeper writes down on...
June 26, 2007 at 2:13 am
1 divided by 3
As an integer (yes I know as zero as you keep on stating)
or
As a decimal number with a number of decimal places to a certain accuracy within the...
June 25, 2007 at 3:01 pm
1/3 - 1/3 = 0
Right?
Hope you not gonna deny this.
No and I never did. I only stated
0.33 - 0.333333 = -0.003333
and
0.33 - 0.333333 <> 0
June 25, 2007 at 6:47 am
Did you see the script?
Yes
Did you understand it?
Yes
I have never assigned 0.33 or 0.3333333 to any variable.
Yes you did, you assigned the rounded result of the division to the variables
SET...
June 24, 2007 at 8:58 am
wow you showed that .33 minus .333333 equals -.003333 and -.003333 rounded to 2 decimal places equals .00
I could have done that, but what has that got to do with...
June 24, 2007 at 7:29 am
Can you give any reference to any math rule which implies those zeros?
No.
But if 1.23 expressed to 6 decimal places is 1.230000, then, if the trailing zeros are not implied...
June 24, 2007 at 6:44 am
Viewing 15 posts - 1,516 through 1,530 (of 3,544 total)