SELECT CONVERT([int],11.25)-CONVERT([int],'10.25')
How to avoid error and return 1 as result.
>Solution :
Rather than using the implicit behaviour of the CONVERT function, why not use the correct function, e.g. ROUND
SELECT ROUND(11.25, 0)-ROUND(CONVERT(DECIMAL(9,2),'10.25'), 0)