Converting Lat Lon to Geometry
Hi All bear with me if this is the wrong forum i have SQL code to use in VB for converting Lat Lon to Geography but need to convert to Geometry any help much appreciated.
Code:
"UPDATE [dbo].[MyTable_Temp_Geo] SET [GEO_Location] = geography::STGeomFromText('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + CAST([Latitude] AS VARCHAR(20)) + ')', 4326)"
Re: Converting Lat Lon to Geometry
Not sure if it's in the right forum or not. What is happening with the code you have? Are you getting errors, if so, what are they?
Re: Converting Lat Lon to Geometry
If your issue is with the SQL rather than the VB code that executes the SQL then this should be in the Database Development forum. If you specify that that is the case, Shaggy can move the thread for you.
