October 8, 2002 at 7:05 am
I am getting the error:
Syntax error converting the varchar value "I500900002" to a column of datatype int.
when doing a
select * from mytable where id=10079
or a
delete from mytable where id=10079
What is going on and how do I get the data out of my table? The data was loaded in early 2002, before our upgrade to SQL2k. I suspect that this is an bug related to the upgrade. (?) Can't find any KB article on it.
October 8, 2002 at 7:12 am
It may be useful to see your table structure, but out of interest is mytable a table or a view?
October 8, 2002 at 7:19 am
It's a table. Here is the definition (sorry if the format looks bad). BTW, I paraphrased in the first mail, the id is SALES_INDICATOR_ID.
COLUMN_NAMETYPE_NAMEPRECISIONLENGTH
SALES_INDICATOR_IDnumeric() identity1820
INVOICE_DATEdatetime2316
APPLICATION_SEGMENT_CODEvarchar66
OBJECT_CODEvarchar88
END_USE_CODEvarchar88
SUBSTRATE_TECHNOLOGY_CODEvarchar88
DATA_TYPE_CODEvarchar66
PRODUCT_CODEvarchar2020
LOCAL_CURRENCY_CODEvarchar33
TRANSAC_CURRENCY_CODEvarchar33
SALESMAN_CODEvarchar1111
CUSTOMER_CODEvarchar1515
INVOICE_NUMBERvarchar1515
INVOICE_LINE_NUMBERvarchar1515
QUANTITYnumeric1517
SALE_AMOUNT_TRANSACnumeric1517
SALE_AMOUNT_LOCALnumeric1517
SALE_AMOUNT_CHFnumeric1517
GROSS_SALES_TRANSACnumeric1517
GROSS_SALES_LOCALnumeric1517
GROSS_SALES_CHFnumeric1517
INVOICED_NET_LOCALnumeric1517
INVOICED_NET_TRANSACnumeric1517
INVOICED_NET_CHFnumeric1517
NET_SALES_LOCALnumeric1517
NET_SALES_CHFnumeric1517
NET_SALES_TRANSACnumeric1517
CHARGES_LOCALnumeric1517
CHARGES_TRANSACnumeric1517
CHARGES_CHFnumeric1517
TAXES_LOCALnumeric1517
TAXES_TRANSACnumeric1517
TAXES_CHFnumeric1517
VIEW_TYPE_CODEchar11
REBATE_LOCALnumeric1517
REBATE_TRANSACnumeric1517
REBATE_CHFnumeric1517
YE_REBATE_LOCALnumeric1517
YE_REBATE_TRANSACnumeric1517
YE_REBATE_CHFnumeric1517
PENALTIES_TRANSACnumeric1517
PENALTIES_LOCALnumeric1517
PENALTIES_CHFnumeric1517
RE_INVOICED_LOCALnumeric1517
RE_INVOICED_TRANSACnumeric1517
RE_INVOICED_CHFnumeric1517
CREATED_ONdatetime2316
PRODUCT_COST_BUDGET_LOCALnumeric1618
PRODUCT_COST_BUDGET_CHFnumeric1618
PRODUCT_CONV_COST_BUDGET_LOCALnumeric1618
PRODUCT_CONV_COST_BUDGET_CHFnumeric1618
PRODUCT_MAT_COST_BUDGET_LOCALnumeric1618
PRODUCT_MAT_COST_BUDGET_CHFnumeric1618
PRODUCT_COST_STANDARD_LOCALnumeric1618
PRODUCT_COST_STANDARD_CHFnumeric1618
PRODUCT_CONV_COST_STANDARD_LOCALnumeric1618
PRODUCT_CONV_COST_STANDARD_CHFnumeric1618
PRODUCT_MAT_COST_STANDARD_LOCALnumeric1618
PRODUCT_MAT_COST_STANDARD_CHFnumeric1618
PRODUCT_COST_ACTUAL_LOCALnumeric1618
PRODUCT_COST_ACTUAL_CHFnumeric1618
PRODUCT_CONV_COST_ACTUAL_LOCALnumeric1618
PRODUCT_CONV_COST_ACTUAL_CHFnumeric1618
PRODUCT_MAT_COST_ACTUAL_LOCALnumeric1618
PRODUCT_MAT_COST_ACTUAL_CHFnumeric1618
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply