I have a table with about a million records in it. I need to alter the data in one of the columns to add some info to it so I want to just perform a
INSERT INTO TABLE-NEW
SELECT {MYQUERY} FROM TABLE-OLD
When I do this I get the error:
OLE DB provider 'SQLNCLI' for linked server 'MYSERVER' returned invalid data for column 'TABLE-OLD.problemfield'.
The data in that column is a float data type with some fractional number that appears to be different for every record. There really is not a way I can sort through it to see what the problem is so is there a way I can just have the insert query run and ignore problem records?
INSERT INTO TABLE-NEW
SELECT {MYQUERY} FROM TABLE-OLD
When I do this I get the error:
OLE DB provider 'SQLNCLI' for linked server 'MYSERVER' returned invalid data for column 'TABLE-OLD.problemfield'.
The data in that column is a float data type with some fractional number that appears to be different for every record. There really is not a way I can sort through it to see what the problem is so is there a way I can just have the insert query run and ignore problem records?