|
padhma.p
Yak Posting Veteran
91 Posts |
 Posted - 2010-03-03 : 16:30:13
|
| Hi,I am trying to insert data from a query into a table.I get an error:Msg 8114, Level 16, State 5, Line 1Error converting data type varchar to numeric.Query:insert into StoreInventory_WAselect dbo.BN_STORE_INVENTORY_FULL.STORE_NUM, dbo.BN_STORE_FULL.STORE_DESC, dbo.BN_STORE_FULL.STATUS_DESC,dbo.BN_STORE_FULL.REGION_DESC, dbo.BN_STORE_FULL.STATE,dbo.BN_STORE_FULL.CITY, dbo.BN_STORE_FULL.ADDR_LINE1, dbo.BN_STORE_FULL.MGR_NAME, dbo.BN_STORE_FULL.STORE_PHONE, convert(varchar, convert(datetime, FIRST_ORDER_DATE), 101) + ' ' + convert(varchar, convert(datetime, FIRST_ORDER_DATE), 108)AS FIRST_ORDER_DATE,dbo.BN_STORE_INVENTORY_FULL.FIRST_ORDER_QTY,convert(varchar, convert(datetime, FIRST_RECEIVE_DATE), 101) + ' ' + convert(varchar, convert(datetime, FIRST_RECEIVE_DATE), 108)AS FIRST_RECEIVE_DATE,dbo.BN_STORE_INVENTORY_FULL.FIRST_RECEIVE_QTY,convert(varchar, convert(datetime, FIRST_SALE_DATE), 101) + ' ' + convert(varchar, convert(datetime, FIRST_SALE_DATE), 108)AS FIRST_SALE_DATE,convert(varchar, convert(datetime, LAST_SALE_DATE), 101) + ' ' + convert(varchar, convert(datetime, LAST_SALE_DATE), 108)AS LAST_SALE_DATE,dbo.BN_STORE_INVENTORY_FULL.ON_ORDER_QTY, dbo.BN_STORE_INVENTORY_FULL.ON_HAND_QTY, dbo.BN_STORE_INVENTORY_FULL.RETURN_QTYfrom dbo.BN_STORE_INVENTORY_FULLfull outer join dbo.BN_Store_FULLon dbo.BN_STORE_INVENTORY_FULL.STORE_NUM = dbo.BN_Store_FULL.STORE_NUMwhere dbo.BN_STORE_FULL.STATE = 'WA'Can someone help me out there please.Thank you. |
|
Error converting data type varchar to numeric.