i have two tables TABLEA and TABLEB
in TABLEA , i have some column where float values are stored but column type is varchar , but when i tried to insert
values from tablea to table by using following statement it is showing conversion error.
Tableb have float type of column where i want to store those columns data from tablea.
insert into tableb(varcharcol, varcharcol, floatcol , )
select varchardata, varchardata , floatdatastoredinvarcharcol, floatdatastoredinvarcharcol