>>I have a table of voter info called Farmers with 92K rows in it. I also have a table of voters called tblCamp_CT with 9 million rows. I added a column to tblCamp_CT called 'IsFarmer' TINYINT.
>>
>>I now need to go through the Farmers table and for every row find the person in the tblCamp_CT using First Name, Last Name, Middle Name, and maybe some other info. If that person exists in the tblCamp_CT table, then set IsFarmer to 1.
>>
>>Wat's the best way to do something like this?
>
>
>WHILE (2 > 1)
> BEGIN
> BEGIN TRANSACTION
> UPDATE TOP ( 10000 ) tblCamp_CT SET isFarmer = 1
> FROM tblCamp
> INNER JOIN Farmers ON ....
> WHERE tblCamp.isFarmer = 0
>
> IF @@ROWCOUNT = 0
> BEGIN
> COMMIT TRANSACTION
> BREAK
> END
> COMMIT TRANSACTION
> END
>
Ok, thanks. I was thinking of using SSIS, but this works for me.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people