Hello
I also enjoyed using this article and all works except that I get an error in Visual studio when I try to use the store procedure with a dynamic addressm(it just refuses to let me use the ?-mark and says I have a syntax error)
this is the sentence i use
EXEC[dbo].[SPGeocode]
@Address = ?,
@City = NULL,
@State = NULL,
@appid = N'MyyahooId'
I am trying to get the latitud/longitude for a number of addresses. I call the procedure from within a FOR each LOOP. If I use a given address it works. I also worte a standard procedure that takes a text and inserts a record. It also works with my ?-mark.
What do I need to do to be able to use a dynamic input for the Address parameter?
regards lima