insert into tbl_item_mst
select itemcode,itemname,shortname,companyname,[description],pack,
convert(numeric(18,2),pricetoretailer),convert(numeric(18,2),mrp),convert(numeric(18,2),standardrate),
itemtype,categorycode,divisioncode,brandcode,
pricetostockiest,null,0,'',0,GETDATE(),null,null,0,'',''
from items
I've been executing above mentioned query I am getting error which i have been mentioned in down.
Msg 8152, Level 16, State 2, Line 1
String or binary data would be truncated.
The statement has been terminated.