First, the query without the dbo.MyTab works as expected in SQL Server 2005.  I also ran it under SQL Server 2000 and got the unexpected result you reported.  I then...

Sergiy,

You also seem to have trouble recognizing the humor in Jeff's and David's posts.

Sergiy,

Unnecessary and wrong are two different things.  It may not be necessary to explicitly drop temp tables at the end of a stored procedure, but that does not mean it...

Sergiy,

I have already admitted to being a Type A personality when it comes to my job.  I am very confident in my skills as a programmer and DBA.  I will...

Sergiy,

Let see, here is what I said:

You have never proved your point, nor will you ever prove your point.  You have consistantly gone off on tangents (really, what the heck...

Sergiy,

You have never proved your point, nor will you ever prove your point.  You have consistantly gone off on tangents (really, what the heck does the Catholic Church 400 or...

Sergiy,

You keep saying that the use of the Bankers Round function is illegal in NZ, that's fine.  That doesn't mean it is illegal every where else.  Just curious on the...

Sergiy,

Actually, in this case, I would round the weight (1.125 kg) to 1.13 kg.  I would use the the Banker Round function in the calculation (rate * weight) to determine...

Actually Sergiy, 0.1250 is precisely the value you get from the ratio 1/8.  Divide it out on paper after the 0.125, all you will ever get is zeros.

The variable @AOwner is no longer exists after the UPDATE statement, as you terminate the batch with a GO statement.  If you can determine the client by querying the database,...

That I can't really answer.  I know enough about hardware to support my computers at home and get in trouble at work, but if the disk is mirrored, I would...

Ran your test code on a server running SQL Server 2000 SP3a using QA:

declare @A float

declare @b-2 float

SET @A = 2

SET @b-2 = 3

SELECT @A/@B*@B, @A/@B/100*@B*100, @A/@B

---    ---------------------   ----------------------

2.0   ...

You could be using SQL Server 7 based on the forum name at top.

Thank you.  Was that so hard?

How about getting off your high horse and answer a straight question with a straight answer.  I asked about the environment you ran your test in.  I was trying to...