Thinking outside the box

Patron Saint of Lost Yaks
posts - 202, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories
<< Getting errors when working with Excel and SQL Server | Home | Cursor is really faster than set-based solution for weighted moving average? >>

First test with November CTP

declare

 @sample table (p geography)

insert @sample
select geography::STGeomFromText('POINT(12.65100 65.34900)', 4619) union all
select geography::STGeomFromText('POINT(35.65100 23.34900)', 4619) union all
select geography::STGeomFromText('POINT(64.65100 12.34900)', 4619)

DECLARE @h geography

SET @h = geography::STGeomFromText('POINT(47.65100 -122.34900)', 4619)

SELECT p.STDistance(@h) / 1000 as [km]
from @sample

Print | posted on Thursday, November 22, 2007 11:38 PM | Filed Under [ SQL Server 2008 ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Peter Larsson