Bring it on.

I just posted you one of those numbers where BR fails:

Value 0.1251 presented with different precisions is treated by BR differently.

In mathematics one example of failure is enough...

It's a number.

Its mathematical notation is 0.(3) .

Anybody who attended school knows that.

So, the question is still the same:

How you store 0.(3) in computer?

Davis,

you forgot to show how 1/3 is stored in your computer.

Please, waiting for you response.

And what if the first digit BEYOND supplied precision is not zero?

How can you tell?

And if it's not, it must be rounded up, right?

1.

> Me: Please run the statement "Debug.Write((2 / 3) * 3)" in the aforementioned environment. (Hint, it does indeed return 2)

What is the datatype returned by Debug.Write?

What is the precision...

Subscriber does no have any seed.

IDENTITY is not replicated if it's NOT FOR REPLICATION.

Subscriber just gets whatever value appears in replicated database.

Including the cases when identity was bypassed (IDENTITY_INSERT ON).

1. "2" with which precision?

If display does not show you following digits it does not mean they don't exist.

"2.0" displayed on screen is not "2.(0)"

So, your result does not prove...

> Want a different one? How about 1/7?

What about irrational numbers?

So, you can to code, but you never did.

That means you have never stored 1/3 in computer for all your life.

Cool.

Is there anybody who has an experience of storing 1/3...

I wonder where do you store "Repeating number bit" and "Number of repeating digits" in DECIMAL(12,6) cell?

Would you mind to stick to real world, to real computers, not the one...

Noel,

but seriously, what's the problem with IDENTITY NOT FOR REPLICATION?

It worked for me without any complications.

Where is a pitfall?

It's not that bad to be called ignorant.

It's much worse to be such.

Look couple of pages back and see how I store 1/3...

Foreign key is much more reliable feature for this.

From my experience I can tell that Sequence TABLES is common VB developers knowledge, not DBA.

It's funny nobody can provide a way to store 1/3 in computer.

Is anybody here a programmer?