Hy Jann, Thanks for your feedback, yes its much better to let the DB do the processing. Is it possible to see the sql code you used for the stores procedure?
I need to display results like this for a real estate agents database: Realtor A - Phone - Zipcode - Distance Realtor B - Phone - Zipcode - Distance Realtor C - Phone - Zipcode - Distance The realtors closest to the search zipcode show up at top, the ones farthest at bottom. So the results are sorted by distance. Thanks, Pardeep. ----- Original Message ----- From: "Jann E. VanOver" <[EMAIL PROTECTED]> To: "SQL" <[email protected]> Sent: Wednesday, February 23, 2005 5:18 PM Subject: Re: Zipcode radius sqlcode > FYI, the accuracy of your distance calculations is dependant on the > number of decimal places in your Zipcode data. > > I know this because I work with zip code tables with 6 digits of > precision, and the distances I can compute with those are VERY > inaccurate. They're all relatively correct, they're just not right. > > I've put my code into a stored procedure so I can link the zips with the > tables that define the retailers I'm covering. That way the relation > between Zip distance and Retailer location can be done inside SQLServer > before sending anything back to CF. > > > J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2167 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
