Tuesday, 6 August 2013

Level 16, State 5, Line 1 Error converting data type varchar to numeric

Level 16, State 5, Line 1 Error converting data type varchar to numeric

I am having trouble with the following SIMPLE query:
INSERT INTO table (
[Date],
[Name],
[Weight],
[Position],
[Effective_Maturity],
[Yield_to_Worst],
[Modified_Duration],
[OAD],
[CTD],
[OAC],
[OAS],
[Coupon],
[Credit_Rating],
[CUSIP],
[Market_Value],
[Principal],
[Yield_to_Maturity])
VALUES
('6/28/2013','ISHARES BARCLAYS TIPS BOND
FUND','100','0','8.647','0.0772','0.0772','3.8629','8.204','8.2040','1.112','9.034','1.543','AAA','TIPETF','1796461','178696')
GO
I'm not sure which variable in my table cannot be converted to numeric and
my knowledge of data types in MS SQL is lacking. However, I think most of
these inputs correctly fit their respective data types. The table data
types are:

Thanks!

No comments:

Post a Comment