I have no idea if this will help you 🙂

But I'm having the exact same issue with a site I'm working on and research has led me to this hotfix

yea the problem is that I don't know how to catch it when it is an issue really

I just check the logs and I see exceptions in there

So I'll need...

The problem stems from an ongoing hack to our DB while we're waiting to upgrade to a new software system so we can get rid of all our triggers 🙂

So...

Yea that's what I just finished doing actually 🙂

and finally found the nested down culprit

Thanks for the advice

andrewd.smith (2/26/2009)

One quick question.... What's the logic behind the bounding box?

Where Longitude between @Longitude-.1 and @Longitude+.1

And Latitude between @Latitude-.1 and @Latitude+.1

Is...

I think that you will find that this is not only orders of magnitude faster, but gives the correct results also:

CREATE INDEX dbo.Table1_LngLat on dbo.Table1 (Longitude,Latitude)

go

DECLARE @LATITUDE AS FLOAT

DECLARE @LONGITUDE...

??

the excel file lives in the Database....

I want to eliminate the step of having to read from a file on the system...

The user uploads an excel file

This file is saved...