Thinking outside the box

Patron Saint of Lost Yaks

posts - 180, comments - 543, trackbacks - 1

My Links

News

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

Feedback

No comments posted yet.

Post Comment

Title
Name
Email
Url
Comment
Remember Me?
Please add 5 and 2 and type the answer here: Enter the code shown above: