>100 cities become 100 * 100 / 2 records - 100 = 5,000 records - 100 = 4,900 records
>
>ie
>The distance from New York to Dallas is the same as the distance from Dallas to New York
Correct, thanks for the clarification.
I still do not understand one part at the
http://msdn.microsoft.com/en-us/library/ms980211.aspx page. They have a section in Formatting the Data about how they calculate the XAxis, YAxis and ZAxis. Then, a few lines below, the come up with a different formula. I am not sure which one I should take. Even by having tried them both, I end up with two different results in my query, and both results are not good.