Not the best approach I've ever seen.

Actually, one of the worst.

Why not just include the check into the trigger itself?

Create Trigger .. blah-blah-blah

AS

BEGIN

IF dbo.IsOwner(suser_sname()) = 0

RETURN

[Trigger body]

END

Of course, users must...

Can you give an example of my rude tone asking you for something?

> If you are so concerned about 2000 forum why are you talking about database mirroring ?

It's you...

Sorry, it's SQL Server 2000 forum.

Pay more attention to your words.

You post your suggestions to SQL 2000 users, and they don't work for them.

And what's so wrong about askung for...

Right, David, business requirement.

Let's see.

You get the amounts to pay from where?

Weight*price.

Right?

Price is written on the wall, but where do you get weight?

From digital weights.

Right?

Now, how those digital weights...

Cath,

as soon as you started off-topic, out of curiosity - what are those interesting things you have learnt about mathematics from this thread?

David, so boring!

I said money, not int.

I said decimal(12,6), not int.

Go to programming courses and learn how to declare variables and assing values to it.

You are boring, David.

Show everyone how implied zeros can make it true:

1/3(money + implied zeros) - 1/3(decimal(12,6) + implied zeros) = 0.00 (whatever datatype + implied zeros)

(Do it on...

> Because it's a boring game.

Yeah, you're right.

It becomes really boring.

Guys are so low, they don't even understand the level of stupidity they expose.

Mathematical abstraction is something...

1. You typed "Round(.1250,3)"

But the whole thing was about rounding to 2 decimal numbers.

That's where TR and BR return different results.

So, keep to the topic.

You typed there "> .12500"

It's...

"That's all you need to do."

Was it you or somebody else?

You're making really funny noises, David.

"Again, prove that TR sees the precise number 0.3333 as all values between 0.3333(0) and 0.3333(9). That's all you need to do. "

Is it your words?

So, don't skip around.

Let's finish with one question before we move to next ones.

So, no proof to back up your absurd claims?

No, TR takes 0.1250 as = 0.1250.

Can you provide any proof for this?

-----------

There is no such value as 0.1250.

0.1250 is a limited precision decimal representation of some...

Are you sure TR takes 0.1250 as < 0.1250(0)

Any proof for this?