well , it's not working at all, i'm trying this: and it takes too long, don't know any idea???

declare @areadesc char(50)

DECLARE csrSites CURSOR FOR

SELECT area_code FROM billable_temp

select @count=(select count(*) from billable_temp)

Open csrSites

FETCH NEXT FROM csrSites INTO @areacode

WHILE @count > 0

select @areadesc=(select distinct areadesc from rates1 where areacode=@areacode)

select @count = @count -1

update billable_temp set country = @areadesc

CLOSE csrSites

deallocate csrSites