CREATE PROCEDURE spUpdateLonLat
	@StoreTableName nvarchar(500) = 'Retailers'
AS

DECLARE @SQL AS nvarchar(750)
Set @SQL= 'UPDATE '+@StoreTableName+' SET '+@StoreTableName+'.Lon = Zips.[lon], '+@StoreTableName+'.Lat =Zips.[lat] FROM '+@StoreTableName+', Zips WHERE '+@StoreTableName+'.PostalCode=Zips.[Zip]'
EXEC (@SQL)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO