Data Conversion Error

• Stylez

  SSCrazy

  Points: 2195

  More actions

  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

• daniarchitect

  SSCommitted

  Points: 1727

  More actions

  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