|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104,
Visits: 8,528
|
|
It's a fair point, alastair. In retrospect, although I knew about this layers of formula accuracy issue, I failed to take it into account in my article's original statement. There i was only taking into account the mathematical accuracy of the Law of Cosines equations. I failed to account for the physical inaccuracy of the model assumed by the formula, which does reduce it's actual accuracy down to about 2-3 places.
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, March 08, 2010 4:26 PM
Points: 1,
Visits: 12
|
|
| The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistance
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104,
Visits: 8,528
|
|
stevewagner (5/21/2009)
The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistance
Yes, the sample test code has a typo in it. jcrwf02 caught this earlier also. Silly me I decided to "improve" the name right before I posted it, so ofcourse I didn't change it everywhere.  .
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 1,060,
Visits: 3,834
|
|
RBarryYoung (5/21/2009)
stevewagner (5/21/2009)
The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistanceYes, the sample test code has a typo in it. jcrwf02 caught this earlier also. Silly me I decided to "improve" the name right before I posted it, so ofcourse I didn't change it everywhere. .
Still, only a very minor issue with an extremely useful set of code. Working on a project right now using it, which will develop into a whole suite of reporting I'm sure once the users sink their teeth into it.
Thanks again!
Jon
---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104,
Visits: 8,528
|
|
jcrawf02 (5/22/2009)
RBarryYoung (5/21/2009)
stevewagner (5/21/2009)
The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistanceYes, the sample test code has a typo in it. jcrwf02 caught this earlier also. Silly me I decided to "improve" the name right before I posted it, so ofcourse I didn't change it everywhere. . Still, only a very minor issue with an extremely useful set of code. Working on a project right now using it, which will develop into a whole suite of reporting I'm sure once the users sink their teeth into it.
Cool! Thanks for the feedback, Jon. 
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 1,060,
Visits: 3,834
|
|
FYI, first report using this is estimated to save 5-7 hours a month in FTE time. They used to have to hunt and peck to find the closest location, guessing by zip code or county, now they have a report that runs in 1.5 minutes.
Thanks again!
Jon
---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104,
Visits: 8,528
|
|
jcrawf02 (7/24/2009)
FYI, first report using this is estimated to save 5-7 hours a month in FTE time. They used to have to hunt and peck to find the closest location, guessing by zip code or county, now they have a report that runs in 1.5 minutes.
Thanks again!
Jon
Sweet! Always nice to hear something like that.
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
