Posted by rcamarda on 05/03/06 04:20

Update:
this is returning rows, but its like 10 separeate selects. I need to
get this into a table

declare @c1 float, @c2 float, @c3 varchar(50), @c4 varchar(50), @state
varchar(10), @zip varchar(10), @country varchar(20)
declare @precision varchar(50), @warning varchar(50)
declare @address1 varchar(50), @city varchar(50)
declare @appid varchar(20)
declare @char1 varchar(20), @char2 varchar(20), @char3 varchar(20),
@char4 varchar(20)

set @appid = 'warehouse-test'

declare cur cursor fast_forward
for select top 10 student_address1, student_city, student_state,
'warehouse-test'
from student

open cur
fetch next from cur into @address1, @city, @state, @appid
while @@fetch_status = 0
begin
exec SPGeocode @address1, @city, @state, 'warehouse-test'
fetch next from cur into @address1, @city, @state, @appid
end
close cur
deallocate cur

• Next in forum: An odd quandry.
• Prev in forum: Re: How do I use pass data to/from stored procedure
• Thread view: Re: How do I use pass data to/from stored procedure

[Reply to this message]