DECLARE @MYDECVAR DECIMAL

DECLARE @MYINTVAR INT

SET @MYDECVAR = 100.123

SET @MYINTVAR = CAST(@MYDECVAR AS INT)

SELECT @MYINTVAR

This returns 100, not 100123 as it should.