Hi Everyone -

Here is the latest copy of my code.

Estelle

/****** Object:  StoredProcedure [dbo].[spGeocode]    Script Date: 2020/05/28 10:39:12 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[spGeocode]

@GPSLatitude numeric(18, 6),

@GPSLongitude numeric(18, 6)

AS

IF OBJECT_ID('tempdb..#xml')...

Hi Steve -

I managed to get this resolved by storing the @result value in a temporary table. Thanks for the side note on SQLCLR.

I will share a copy of the...

Here is the code:

CREATE PROCEDURE [dbo].[spGeocode]

@GPSLatitude numeric(18, 6),

@GPSLongitude numeric(18, 6)

AS

DECLARE

@Address varchar(80),

@City varchar(40),

@State varchar(40),

@Country varchar(40),

@PostalCode varchar(20),

@County varchar(40),

@MapURL varchar(1024);

SET NOCOUNT ON

DECLARE @URL varchar(MAX)

SET @URL = 'http://maps.google.com/maps/api/geocode/xml?latlng=' + CAST(@GPSLatitude AS varchar(20))+','+CAST(@GPSLongitude AS varchar(20))+'&key=x'

SET...

• This reply was modified 4 years, 9 months ago by  Stella86.

Hi Steven -

The @result contains NULL. I suspect it is because the GET request is to an HTTPS site? When I copy the URL into the browser, I do get...

Hi there -

Did you maybe manage to resolve this issue? Struggling with the same thing...

Thanks

Estelle