Make INSERT INTO continue even when an error occurs

[JordanCN2]

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?

 

[markros]

No, unfortunately not. You may want to filter non-numeric items using ISNUMERIC function.

PluralSight Learning Library

 

[JordanCN2]

Thanks, That worked out for me.

I don't know how the strange data got into the float field, but this worked out.