Post reply

Data Conversion Error

  • December 10, 2014 at 11:01 am

    #100200

    Good Morning Guys,

    I Would Like to ask. when I run this particular Select Statement inside a stored procedure, I am encountering this error

    'Error converting data type nvarchar to float'

    i have attached the Select statement I used to retrieve the data. any help from your part is very much appreciated

    Best Regards,

    Noel

  • December 30, 2014 at 12:43 pm

    #1767064

    a2.NumericValue check distinct values for this column,

    you might have anything other than numeric values.

    or add , and a2.NumericValue like '%[0-9]%'

    like below.

    Select top 1 a2.numericvalue

    from dbo.ctc_mde_valueaudit a2

    where a2.UTagId = mva.UTagId

    --And mva.id > a2.Id

    and a2.NumericValue is not null

    and a2.NumericValue like '%[0-9]%'

    /*and a2.NumericValue is not null and a2.NumericValue != 0

    and mva.NumericValue is not null and mva.NumericValue != 0*/

    order by a2.id desc

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply