• Thanks for your ideas. I'll look into them. By the way, do you mean this below on the usage of alias in UPDATE?

    UPDATE asft SET LastRemoved = NULL

    instead of

    UPDATE asset.tblAssetSoftware SET LastRemoved = NULL