> But I'm curious how often it gets it wrong in real world usage.

Every time BR returns not the same result as TR.

You did not answer: is there a...

Set trigger FOR UPDATE on MyControlTable to perform updates on other tables.

Use value from table "inserted" instead of @last_assigned_id.

And because trigger is a natural tansaction you don't need to declare...

It can.

If you'll figure out where is a place for 2/3 in your computer.

From where?

From another SP or from application?

Create a rule:

AS

@CrCd LIKE '[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'

Then create a user datatype based on this rule.

Every number will be validated once when stored.

No further validation required.

Probably it would be a good idea to...

select * from Table

where customerID = @customerID OR @customerID IS NULL

Normalize your table.

Michael,

please READ AND UNDERSTAND my previous post.

Please READ AND UNDERSTAND.

I did not reference any number of bits in it.

Because it does not matter.

How many numbers between 0 and 1...

There are no numbers represented "accurately enough".

Between every "precise" value represented "accurately enough" there are infinitely many "imprecise" values which cannot be represented "accurately enough" with any decimal reprecsentation, with...

I'm not cheating.

Those numbers are numbers from real world.

Which come to your computer to be stored with 3 digits precision.

Point is - even with so poor precision your computer can...

Michael,

does you computer support only 1024 values between 0 and 1?

I tell you, there are much more.

Infinitely more.

Limited precision (in you example - very limited precision

Every minute in a period you are working with.

If you match daily T&A reports - it's for a day.

If weekly - for a week.

And "ID" means any not nullable column...

Should be

EXEC @return = sp_executesql @SQLCommand

SET @ErrNo = @@Error

IF @return 0 OR @ErrNo 0

GOTO ErrorHandler

Lynn, you are really funny guy!

You really need to learn to be professional. Name calling is not good form.

Was it about yourself?

Because it's you who introduced name calling...

Your problem is you are "minor in math".

That's why you cannot understand mathematical proof.

Sorry.

But at least you understood "You don't know".

Not so bad for beginning.

Keep trying. Probably one day you'll...