What does the query plan look like? Any chance that parallellism is killing performance?

O M G !!!

Unless you don't have a choice and have to pay to monopolists whatever they ask.

You always have a choice.

Just to open your eyes that it is not YOU who defines the business rules to follow, for every country in the world.

If some company prefers "Banker's rounding", fine. If...

That is what rounding is all about!

Some will loose and some will gain. Next time it can be the other way round.

I don't mind spend half a cent due to...

Who says that rule is the only one available on the earth?

We use another strategy: all cents >= 0 and < 50 rounds down and all cents >= 50 and < 100 rounds...

If I thought you are doing a great job, yes. But I don't.

Why do you think it is SO unfair to "loose" half a cent?

So you loose half a cent two times? 1 cent in total?

Charge one cent more to client?

Maybe you loose one cent one time, and win one cent another time?

Sergyi, I want you to pay me 1.0450000000000001 dollar for consulation.

Can you do that?

How are you going to pay me that 100 atto-dollar?

Thank you Lynn.

Business decisions is the directive here, not real world.

Exactly!

And the accepted precision level is set by the algorithm of the "Banker's rounding".

You finally got it Sergiy! Congratulations.

Once again, you miss the point.

I know exchange numbers are sometimes displayed as fractions, but that is not intended for common people.

If you buy 200 dollars, do you get a...

As you also surely must know, the representation of the printed value on the paper or coin is an equivalent value of a working effort or a thing. The government issuing...

O M G !!!!

Are we talking about relativity now? Heisenbergs principle?

Beacuse atoms free themself when temperature raises, does that mean a dollar lying on a desk in the sun is...

If there is supposed to be a space in the fieldname, use

SELECT * FROM OPENQUERY(LinkedServer, 'SELECT fiel1, field2, field3, field4,field5 FROM tablename WHERE [field 1] = 10' )