> it could be a mix (11, 11A, 11B, 12) and it can even be alpha leading (S1, S2, etc.).

Just wait for 123 which is 12+3, and must go after...

Not gonna tell I'm an expert in replications.

I did replications for couple of databases (nobody requested more yet ) and IDENTITY was not a...

What is it "work"?

So, show how 1/3 is stored in your computer?

Seq. numbers dictate RBAR approach by definition.

Not high transaction rate really.

And simple "NOT FOR REPLICATION" resolves all problems with IDENTITY.

Noel,

You recorder 2 values, none of them is 1/3.

Sorry.

Try

SELECT ShortName , CONVERT(varbinary(200), ShortName)

FROM #TempRecordsToCreate

SELECT MEDIUM_DESC, CONVERT(varbinary(200), MEDIUM_DESC)

FROM CODE_PROGRAM

See if there is a difference not visible by eyes.

Can you record 1/3 in a computer?

> Since when have fractions been imprecise? They are simply the ratio of two integers, both of which are, by definiton, precise.

Are you sayng you are scientist?

Poor science.

For those...

> Until the OP returns and tells us their purpose, it is impossible to be sure that your conclusion, which again is likely the case, is in fact correct.

True.

As...

And in properly designed database assemblies and sub-assemblies should be separated.

Right?

Especially if they mean something for users, and they do, if they ask for...

> You cannot assign 1/3 (fraction) to a decimal variable

Congratulations!

Your computer does not works with 1/3, 2/3, 1/7, 1/9, 1/11 and all other imprecise numbers.

So, it cannot be used for...

Did you see the script?

Did you understand it?

I have never assigned 0.33 or 0.3333333 to any variable.

Where did you find it?

I assigned 1/3 to variables having different precisions.

I showed that...

I understand, it's too hard for you to replace FLOAT with decimal, it's not what programmers suppose to do in their jobs, so I'll do it for you:

DECLARE @One DECIMAL(12,6)

DECLARE...

> The following zeroes are implied

Implied by whom?

Can you give any reference to any math rule which implies those zeros?

> Comparison in math, the least precise number' precision is increased...