Error converting data type nvarchar to float?

[vasavivenu]

Hi,


I need to change data from one database to another database, so i am using

INSERT INTO GSC2.DBO.salebill SELECT *FROM VGP3.DBO.salebill

then it gives a error msg as:
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type nvarchar to float.

Thanks,
vasavivenu

[code green]

The data types of the fields are inconsistent between the two databases