Okay, now that was funny.

Adding a /Y after the COPY command should do the trick for you in most environments.

It's hard to say, without knowing what is driving the search criteria, what is typically searched on, etc., but I can hopefully get you started, keeping in mind that these...

Still waiting on that code, by the way.

I agreed with no such thing. I simply stated that there is no last "9" in .999...

On the other hand, there is a last "9" in .999999999999.

This really isn't rocket...

"Istead of repeating time after time that I'm wrong try to prove it at least once."

That's been done an almost infinite number of times in this thread, including once using...

"Yes, I can specify infinite number of zeros before 1, this is exactly how infinity works."

No you can't, because that is how infinity works. .0~ never ends, therefore there is...

Hell, that's not even true using your methodology. The real value behind 0.125 according to you should actually be somewhere between 0.124 and 0.126, so you would round it up...

Sorry to burst your bubble, but there is no last "9" in the number .999...

That's kind of the point of those three dots.

Here you go.

Or here.

Maybe...

Ah, I reread your code, and you're wanting to use the remote udf on remote data, not local data. There are likely ways of accomplishing what you want, if you give...

Have yourself a grand old time!

For the record, the NYSE no longer trades in fractional representations, and hasn't for quite some time, so Giordy can drop that one from his bag of dime-store tricks.

I'm glad you used that one, as it's just one more place that you're wrong. I agree with Dr. Math, but he doesn't agree with you.

.999... is exactly the same...

Are remote connections for TCP/IP enabled on the box?

If this is more of a "Is it in any way possible, no matter what hoops I have to jump through?" type question, I'm thinking there is a way. I...