Home Forums SQL Server 2008 SQL Server Newbies CAST for DEcimal RE: CAST for DEcimal
David Webb-CDS
SSCoach
Points: 17398
More actions
November 25, 2014 at 10:19 am
#1760876
What does this return?
select cast(@int/1000.00 as decimal(9,1))
Dividing by 1000 may be forcing it to do integer math.