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