Not really.

Infinity is not undefined.

0* infinity depends on the way infinity was received.

If infinity came from 5/0 then 0*infinity = 5

If infinity came from 1/0 then 0*infinity = 1

If infinity...

Infinity is not any number.

0*infinity is not 0.

6th grade math.

Theory of limits.

Go and study.

What is linked server then, if not another implementation of trusted connections?

1/infinity = 0

It's not extremely close, it's infinitely close.

There is nothing more than infinity.

As I said, you missed some very important classes in school.

P.S. Remind everybody, you are ignoring whom?

If you use remote calls regulary and heavily you better have trusted connections established.

Then you don't need to use passwords at all.

You posted procedure INSERTTEST, but your error is in procedure sp_generate_inserts.

It's quite tricky to help you fixind something no one have seen.

It's not exacly about TOP N.

It's about shortest way to the target.

When you do SELECT * in a query involving non-clustered index seek SQL Server needs to perform bookmark lookup...

What is "12.5" value?

Where you've got it from?

It's a result of either some measurement or some calculation (of values measured) stored with some precision you cannot change and have to...

Repeat it 7 times before you go to bed.

It will probably meka you feel happy.

But don't do it on public.

You are ridiculous enough even without it.

Well, for average size of report, say 1000 rows, it will speed up the process by... 8 ms?

Not sure anybody would appreciate this effort.

Unlike the possibility not to invent that...

"the current domain of the server I'm on"

What do you mean?

You need domain of the server or domain of the client?

Then linked server is not your solution.

Linked server suppose to be static.

Do your homework first, then join the discussion.

David, have you done your homework with one thirds?

Try to store 1/3 in DECIMAL(12,6) and DECIMAL(12,4)

Find the difference and see who really gives a crap.