How to fix error The data types float and int are incompatible in the modulo operator.

Replace
  Select Float, Float % 1 As Truncated
  From TestingDecimal2
with
  Select Float, (Convert(decimal(5,2), Float ) % 1) As Truncated
  From TestingDecimal2

Youtube example