Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '0.035764' to data type int. code example
Example: Conversion failed when converting the varchar value to data type int.
CONVERT(INT,
CASE
WHEN IsNumeric(CONVERT(VARCHAR(12), a.value)) = 1 THEN CONVERT(VARCHAR(12),a.value)
ELSE 0 END)