0 - 2 of 2 tags for duplicate rows

Using MSSQL 2000. I have a table with duplicate rows that needs to be updated. I have new values with similar table.
Table A:
UID        Type
11796     30
11796     31
11796     48
11556     302
11556     305
11552     146
 
Table B:
UID        Type
11796     50

Hi,

I have a .txt file which is pipe separated and it has 543895 rows. Duplicate records are avoided by putting a serial number at the end of every row.