Heh... milliseconds per calculation mean a lot if you have millions of shipments to make. And you say what's wrong with being 100% correct? Nothing... but you're 100%...

The only thing that I can figure out is that the optimizer in 2k5 resolves the sub-query before using it... the one in 2k seems to be trying to resolve...

Isn't that strange? It's the GROUP BY loosing it's mind and it doesn't happen in 2k5. Not sure what to do about it yet.

Heh... well never mind... all of the sudden, I'm getting the same bug and I only have a single CPU...

Is it a multi CPU box you're working on? Also,...

anton.vandersteen (11/28/2008)

---

Hello Fellow SQL nerds,

I want to be able to open a file in a sql script.

First I select data via a cursor.

Second, I want to be able to insert...

That would be true. Some good fellow had the link to my Triangular join article with the comment that folks should take a gander. I didn't mean to...

Heh... Great Circle calcs to find closest... doesn't seem to be needed especially in the Temperate zone of latitudes and longitudes limited to only 1/8th the circumference of the Earth....

{insert Jeapordy theme song here} 🙂

I've not seen such a thing... perhaps try using MaxDop 1 just to see if parallelism is getting to it? I'd try it on a multi-processor box if I...

What is it that you think you need a CLR for that can't be done in T-SQL? In other words, what is the CLR that you want to write...

Ummm... that's cool, but most of those methods don't work on alpha-numeric columns.

Chris did it right.

True enough... but they are suppose to imply the ability to think and do a little research on...

Jportelas (11/28/2008)

---

Thanks Sergyi, Matt and Jeffrey, so there is no way to achieve this in T-SQL for SQL Server 2000?

Seems like trying to cover all the failure scenarios is the...

Heh... Read it? I wrote it! 😉