use TerminalData
declare @t  as table  (id  int, SpatialLocation geography)
INSERT INTO @t
			
    SELECT nID,
     ('POINT('+CONVERT(varchar, dbLon) +' '+ CONVERT(varchar, dbLat) +')' )
      FROM AW_TrackLast

DECLARE @g as table  (id  int,SpatialLocation2 geography)
INSERT INTO @g
    SELECT nID, 
    ('POINT('+CONVERT(varchar, dbLon) +' '+ CONVERT(varchar, dbLat) +')' ) 
    FROM AW_TrackLast

declare @x table(dbLon float,  dbLat float)
insert @x values(106.620165, 10.746475)
insert @x values(153.095160, -27.377213)
insert @x values(0.000000, 0.000000)
insert @x values(22.952630, 40.599135)
insert @x values(114.079980, 22.547512)
insert @x values(114.080272, 22.547073)
insert @x values(114.037833, 22.543650)
insert @x values(-115.405117, 32.622633)
insert @x values(114.079867, 22.548733)
insert @x values(106.536433, 21.013733)
insert @x values(100.572567, 13.728350)
insert @x values(400.039067, 3.539083 )

DECLARE @g geography = 'POINT(-121.626 47.8315)';

select *, x.ToString(), x.STDistance(@g)/1000 as Rasstoanie   from (
select *
,geography::STPointFromText('POINT('+STR(dbLon,20,10)+' '+ STR(dblat,20,10)+')' , 4326) as x

 from @x
 ) as a
 ORDER BY x.STDistance(@g)

declare @x table(dbLon float,  dbLat float)
insert @x values(106.620165, 10.746475)
insert @x values(153.095160, -27.377213)
insert @x values(0.000000, 0.000000)
insert @x values(22.952630, 40.599135)
insert @x values(114.079980, 22.547512)
insert @x values(114.080272, 22.547073)
insert @x values(114.037833, 22.543650)
insert @x values(-115.405117, 32.622633)
insert @x values(114.079867, 22.548733)
insert @x values(106.536433, 21.013733)
insert @x values(100.572567, 13.728350)
insert @x values(400.039067, 3.539083 )

declare @g table(dbLon float,  dbLat float)
insert @g values(104.620165, 10.746475)
insert @g  values(156.095160, -27.377213)
insert @g  values(0.200000, 0.000000)
insert @g  values(22.952630, 40.599135)
insert @g  values(112.079980, 22.547512)
insert @g  values(113.080272, 22.547073)
insert @g  values(114.037833, 22.543650)
insert @g  values(-116.405117, 32.622633)
insert @g  values(117.079867, 22.548733)
insert @g  values(108.536433, 21.013733)
insert @g  values(109.572567, 13.728350)
insert @g  values(406.039067, 3.539083 )


 SELECT 
    ('POINT('+CONVERT(varchar, dbLon) +' '+ CONVERT(varchar, dbLat) +')' ) 
    FROM AW_TrackLast



select *, x.ToString(), x.STDistance(@g)/1000 as Rasstoanie   from (
select *
,geography::STPointFromText('POINT('+STR(dbLon,20,10)+' '+ STR(dbLat,20,10)+')' , 4326) as x

 from @x
 ) as a

declare @t1 table(f1 varchar(10))
declare @t2 table(f2 varchar(10))

insert @t1 values('Point1')
insert @t1 values('Point2')
insert @t1 values('Point3')
insert @t1 values('Point4')
insert @t1 values('Point5')

insert @t2 values('Point11')
insert @t2 values('Point12')
insert @t2 values('Point13')
insert @t2 values('Point14')
insert @t2 values('Point15')