Yep. And it doesn't work. The selects below always generate just one record with a count of 4000000.

create table temp1(randnum bigint)

insert into temp1

select top 4000000 rand()*10000000000000

from somebigtable

select randnum,count(*)

from temp1

group by...

But this generates the same random number 4 million times. Maybe that's why he used the cursor.

But for some cases there is just no need for BR - which is different from saying that BR is wrong - or rather, TR will do just fine.

Thus when...

At the time an incident was opened but I think the client I worked for at the time then dropped it. The problem still occurs today but apparently with a...

But thinking more, I'm coming back to your side and I'm, in fact, questioning the need for BR.

Thus, it gets it wrong with a low level of probability because the...

BR is defined differently from TR. That's why it produces different results. I, who have chosen BR instead of TR, want it that way because I like the definition of...

Yes, it's very rarely when it's different, but every time it is it's wrong.

That's what I wanted to hear. And 'every time' is very rarely, i.e. probability around zero.

BR, by definition, is NOT meant to get the same results as TR. And the fact that 2/3 doesn't have a precise place in my 10 bit computer doesn't change that...

I took another look at 0.005/0.111 which, you said, was wrong.  If I reason in a certain way (especially in regards to what BR sees/receives) then it can actually be...

So you think the problem with BR cannot be demonstrated with my 10 bit computer?

Yes, yes, Sergiy - we know all that - it's great stuff.

There are no numbers represented 'accurately enough'.

Although I thought we had agreed that 0.125 was represented exactly by 0.0010000000...

OK, I will give you 4 more bits to play with. Thus 1001.0/8000.0 sits between

0.00100000000010 0.1251220703125000

and

0.00100000000011 0.1251831054687500

Thus we are dealing with 0.1251 which BR rounds perfectly to 0.13.

Of course you...

Sergiy,

You are cheating a bit, i.e. you are doing arithmetic using numbers to 4 digit accuracy whereas all we got is 3 ditigt accuracy....

Sergiy,

I guess with that 4 bit computer I shot myself in the foot because we were not able to go through some reasonable rounding exercises that would allow us to...

Sergiy,

Here are some quick hints on English - no offense - please - it's meant to make us communicate better.

First you need to fix your comments.

This is better rendered as:

I...