SQLTeam.com | Weblogs | Forums

Migrate Work Orders from Old Assets to New Assets



Table W has Work Orders and Table A has Assets.

w.WOPK, w.AssetPK, w.AssetID, w.AssetName


a.AssetPK, a.AssetID, a.AssetName

I need to re-assign WO's to different assets of the same ID and Name, but different PKs.

I imported a duplicate, more accurate copy of assets. The names, and ID's are the same, but the PK's are not.

How do I re-assign the WO's tied to the old assets, to the new assets?