Home Forums SQL Server 7,2000 T-SQL Sum then Divide RE: Sum then Divide
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 1, 2013 at 12:06 pm
#1602555
Based on what you posted:
declare @t_complete int = 176420,
@myCount int = 5265365;
select @t_complete / @mycount, @t_complete / (@mycount * 1.0)
Results:
IntDivision DecimalDivision
0 0.03350574936400