Duration/60 already does an implicit conversion of Duration to an INT
datatype. And if you divide an int by an int, the result will always be
There are a few options that will return the result you expect:
CONVERT(int, SUM(Duration/60.)) As TotalMins -- Note the dot.
CONVERT(int, SUM(CAST(Duration AS FLOAT)/60)) As TotalMins
SUM(CAST(Duration AS INT))/60 As TotalMins
Jacco Schalkwijk MCDBA, MCSD, MCSE
"Joel Gacosta" <com> wrote in message