1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| @OverflowLat = case
when [st_sso].[OverflowLat] is not null and st_sso.overflowlat<>'0|0|0'
then st_sso.overflowLat
else
cast (cast(Latitude as numeric(5,0)) as varchar) + '|' +
cast (abs(cast((Latitude - cast(Latitude as numeric(5,0)))*60 as numeric(5,0))) as varchar) + '|' +
cast (cast(abs(((Latitude - cast(Latitude as numeric(5,0)))*60 - cast((Latitude - cast(Latitude as numeric(5,0)))*60 as numeric(5,0))) * 60) as numeric(5,0)) as varchar)
end,
@OverflowLon = case
when [st_sso].[OverflowLon] is not null and st_sso.overflowlon<>'0|0|0'
then st_sso.OverflowLon
else
cast (cast(Longitude as numeric(5,0))*-1 as varchar) + '|' +
cast ( abs(cast((Longitude - cast(Longitude as numeric(5,0)))*60 as numeric(5,0))) as varchar) + '|' +
cast (cast(abs(((Longitude - cast(Longitude as numeric(5,0)))*60 - cast((Longitude - cast(Longitude as numeric(5,0)))*60 as numeric(5,0))) * 60) as numeric(5,0)) as varchar)
end,
|