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.

El,

There are many books on learning SQL Server... and I realize you may not know enough about it to ask the kind of questions you probably need answers for...

Take a...

aaa or bbb is the primary key and unique????  Why do they show up in your example data more than once?

I still don't understand...

No... but if you want good help... you have to ask better questions and provide a more reasonable representation of what your data actually looks like.  You'll also find that...

No... because it can't be done.  If you don't have triggers to force the update of ModifiedOn and ModifiedBy columns in every table, there's nothing you can do.