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