I get an I/O error when I try to run: update CommonCode set CCData = t2.CCData,CCModified = t2.CCModified+ from CommonCode t1, tmpCode t2 where t1.CCName = t2.CCName+ and t1.CCModified lt t2.CCModified
I am trying to update a code table if the modification date changes CCData is the code=varchar CCModified is DateTime stamp which I want use to update code Both tables exist and I have modified CCModified so it will find data to update Tom Hart
