Insert GEOM field converted to latitude and longitude into a table.
Posted on 2014-12-04
I am running the following on a table to insert a GEOM field:
--insert geometry into XX_XX_INFO table
ALTER TABLE XX_XX_INFO
ADD GEOM GEOMETRY
MERGE INTO XX_XX_INFO
ON Replace(LTrim(Replace(XX_XX_INFO.LOCATION,'0',' ')),' ','0') = EL_METER.LOCATION
WHEN MATCHED THEN
UPDATE SET GEOM = EL_METER.GEOM;
Which works great. But now I need to split that GEOM field into Latitudes and Longitudes and update the table instead of putting the GEOM field into it. I can query the GEOM field to get that info with this:
Geom.Lat as [Latitude],
Geom.Long as [Longitude]
I just do not know how to get it put the lat longs into the table instead of the geometry.
Any help is appreciated.