TR sees any number X.XXXX as any value between X.XXXX(0) and X.XXXX(9)

Proof - it rounds "half way" numbers up.

Logic of such rounding is this:

X.XX50 value represents values X.XX50(0) .....

Got another answer:

Because midnight is 12:00am

and noon is 12:00pm

If you can explain for yourself why midday belongs to pm then you not gonna have...

Because that's the agreement accepted by mathematicians. Some would name it "Standard".

Result of any operation is getting represented by closest lower decimal number.

You may check it with

SELECT 2./3, 8./11,...

I provided perfect proof:

the way TR rounds 0.1250.

As noted earlier, it's time to put up or shut up.

Probably for you - it's right time.

You do know that this directly contradicts the statements you earlier made about computers not being able to handle repeating numbers, right?

Not right.

It does not contradict to anything I...

You welcome.

It was implied.

See the forum name on top of this page.

SQL Server 2000 SP4

Query Analyzer.

You are trying to do mirroring using replica functionality.

Don't think it's right.

Generally speaking replica should not be a copy of publication. By default it does not include anything but tables....

Lynn, which date is correct - the one you're seeing in EM (27/06/2007 11:52) or the one returned by QA (2007-06-27 11:52:15.145) ?

Read about conversion and rounding involved in displaying...

> First off, if any programmer actually tried to pass the fraction 1/3 to a function, I'd fire him on the spot. Happens to you a lot, does it?

If...

You probably mixing mirroring with replication.

Replica should not be populated from anywhere but original database.

If you use right thing in a wrong way it will fail, of course.

In my experience...

> Why would I care what precision it is? You said BR would not return 2 for that statement.

But you do!

It's you who makes the tales about absolutely...

Sorry, David,

none of them is 1/3.

1/3 does not have exact representation in binary.

And you told that approximate is not good enough.

So, still no answer on my question.

Try again.

I was right all the way.

What that spam from you was about?

Any written set of signs is an expression of a number.

Can you show me a number, not a representation?

If to follow your logic, 1.0 is not a number as well,...