Comments by Member 12271876 (Top 8 by date)

I deleted the records(there were not many just 4 records ) that had issues like 203d and trying loading the file again by using bulk insert.
query - BULK INSERT t1
FROM 'C:\Users\abc\Desktop\Newfile.txt'
WITH (FIELDTERMINATOR = '|');

its giving me message - Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (Bus_id).


I delared Bus_id as float this time.

Can u help..?

Ok.. will check. Thanks !

I get no value when i do this.Just blank table with headers.

Yes, sql is unable to find matching records.
If i do search on specific Bus_id records, I am able to see same records in both tables.
Not sure Y sql is unable to find it. is there any other way to tackle the problem..?
I am matching by Bus_id only now.
Update t1
set t1.Revenue = t2.revenue
from t1
Inner Join t2
on t1.Bus_id = CONVERT(NVARCHAR(50), t2.Bus_id);