Hi Lowell,

Your guidance has been very very helpful. The steps abouve are working really nice. I have updated about 8 tables using these methods, but...there is this one table that wont update, resulting in the following error:

Msg 2627, Level 14, State 1, Line 1

Violation of PRIMARY KEY constraint 'PK_WAREHOUSEINFO'. Cannot insert duplicate key in object 'dbo.WAREHOUSEINFO'.

The statement has been terminated.

This bugs me because apparently this table have the same structure as the ones where the update have worked.

But apart from that, everything is going nice and smooth.

Thanks Lowell!!!