Heh... guess you didn't believe the ol' man when he told you the first time, huh, Shwetha?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=388319#bm393497

Or any idea why disk usage is so high during querying?

A large amount of disk reads are...

Yep...  lots'o different tools available, but I'm confused... first post shows 2 items each line, follow on shows 1 item each line... I'm just trying to get AM to post about...

Great... thanks for the feedback, Jim.

Just more info on what they wanted us to do at work... they wanted a similar precalculated table of the distance from every NPA/NXX (area...

I've found that the best thing to do is to have an SQL "Expert" or "Guru" ask some questions of the candidate during an interview.  Remember that the goal of such...

Yes... 100% SQL Server.

What are your distance calculations for?  Telephony, shipping, flights, or ???  And what is the source of your data... does it have only Lat/Lon or does it...

Thanks AM... I should have come right out and said it... can you provide the 10 or 15 rows of information, as well as a handfull of rows where the...

Heh... yeah... just remember, there are TWO worlds in SQL... the external world of GUI's and the internal world of batch processing.  The idea of using ORM and Hibernate and...

You'll find that folks don't appreciate cross posts on this forum very much...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=393540

You'll find that folks don't appreciate cross posts on this forum very much...

http://www.sqlservercentral.com/forums/post.aspx?forumid=7&messageid=393539

Yes... Stop passing the date as a VARCHAR and pass it as a date/time data type or a date serial number.

I agree with Ray... this type of formatting is better done in the GUI if you have one.

Also, the reason why you were getting zeros for your percentage was because...

Hi Jim,

I do the exact same type of "blot" or "grouped" distance calculations your Developers are talking about... find the geographic center of a group... find all items within a...

... or nulls on a blue background, either

Dang... sorry about that... I responded to the first page and didn't look on the 2nd page... sorry Ryan.