[dba-SQLServer] C# / SQL Server: select all zips within 5 miles ofa ZIP list

jwcolby jwcolby at colbyconsulting.com
Mon Mar 15 18:17:38 CDT 2010


Michael,

Thanks for the suggestion.  Maybe but there are only 6 digits right of the decimal in the zip data. 
  Plus floats are native to hardware whereas (I think) decimals are string manipulation in a 
software library.

John W. Colby
www.ColbyConsulting.com


Michael Maddison wrote:
> Hi John,
> 
> Not sure I can help you, I've vaguely done similar stuff but in ESRI GIS
> ArcObjects. All the complex stuff is hidden from you though.
> But, would your results not be more accurate if you used Decimals
> instead of floats and doubles?
> 
> Good luck
> 
> Michael M




More information about the dba-SQLServer mailing list