Here is the actual file I am importing:

Planname,Country,Rate,Effectivedate,R1,R2

WTC_p,Italy,0.021,9/24/2002,30,6

WTC_p,Peru - Lima,0.0228,9/24/2002,30,6

WTC_p,United States,0.025,9/24/2002,30,6

WTC_p,Poland,0.057,9/24/2002,30,6

WTC_p,Colombia,0.0816,9/24/2002,30,6

WTC_p,Philippines,0.105,9/24/2002,30,6

WTC_p,Philippines - Manila,0.105,9/24/2002,30,6

WTC_p,Bangladesh - Dhaka,0.1056,9/24/2002,30,6

WTC_p,Morocco - Casablanca,0.109,9/24/2002,30,6

WTC_p,Ecuador - Guayaquil,0.122,9/24/2002,30,6

This is absolutely beautiful. Simple and effective. Thank you very much!!

Wow, you guys are really working hard on this!! Thanks so much for your help. Yes, the the callcountry column starts out as null. I did try the...

Yes, I have a unique clustered index on recid in the calltable, and index on the callnumber. I created a temp table for the countrycodes table which I tried...

This is what I got. I scripted the tables out. I hope this is what you needed. They are in separate databases.

if exists (select * from sysobjects...

Um, I am kinda a newby. I am not sure how to post the DDL.

I am having a little trouble getting this to work nicely. It is actually running about twice as long as the cursor. Also it is defaulting to the...