DECLARE @g geography
SET @g=
geography::Point([Lat], [Long], 4326) as SAME_GEOM
FROM FencePointsBAHA FB
WHERE (Lat <> 0) AND (Long <> 0) and FenceIDFK=16
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kunal PatelPosted Mar 31, 2016, 3:16 AM
mohan singhPosted Mar 31, 2016, 3:04 AM
Kunal PatelPosted Mar 31, 2016, 2:55 AM
SET @g = ( SELECT geography::Point([Lat], [Long], 4326) AS SAME_GEOM
FROM FencePointsBAHA FB
WHERE ( Lat <> 0 )
AND ( Long <> 0 )
AND FenceIDFK = 16
)