--sample table to illustrate geography data type
IF OBJECT_ID ( 'dbo.SpatialTableGeog', 'U' ) IS NOT NULL 
    DROP TABLE dbo.SpatialTableGeog;
GO

CREATE TABLE SpatialTableGeog 
    ( id int IDENTITY (1,1),
    GeogCol1 geography, 
    GeogCol2 AS GeogCol1.STAsText() );
GO

INSERT INTO SpatialTableGeog (GeogCol1)
VALUES (geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326));

INSERT INTO SpatialTableGeog (GeogCol1)
VALUES (geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326));
GO

--select * from SpatialTableGeog

--Find intersection
DECLARE @geog1 geography;
DECLARE @geog2 geography;
DECLARE @result geography;

SELECT @geog1 = GeogCol1 FROM SpatialTableGeog WHERE id = 1;
SELECT @geog2 = GeogCol1 FROM SpatialTableGeog WHERE id = 2;
SELECT @result = @geog1.STIntersection(@geog2);
SELECT @result,@result.STAsText();

quote:

---

Originally posted by atletico

Hi visakh16 and thanks for your answer.

No this is not what i am looking for. I don't want to get as a result a whole line but only the first point of intersection between the polyline and polygon.Using your example below i want to get the first point in the left in which the polyline and the polygon are being intersected.

Thanks.

---

...
SELECT @result = @geog1.STIntersection(@geog2).STStartPoint();
SELECT @result,@result.STAsText();

DECLARE @line geography=geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326);
DECLARE @polygon geography=geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);
DECLARE @intersection geography=@line.STIntersection(@polygon);
SELECT @intersection.STAsText() Intersection, 
@intersection.STStartPoint().STAsText() EntryPoint, 
@intersection.STEndPoint().STAsText() ExitPoint;